AD 79-10-14 R1
Registered aircraft · 56,582
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N736XBAerospace Trust Management LLC Trustee · Wilmington, DEN736XCEagle Squadron Inc · The Villages, FLN736XDRiverview Flyers LLC · Marysville, PAN736XERegistered aircraftN736XHJlm Ranch Inc · Mullen, NEN736XMNorthwest Passage LLC · Anchorage, AKN736XNColorado Northwestern Community College · Rangely, CON736XSRegistration Pending · Urbandale, IARegistration pendingN736XVFreedom Aviation LLC · Riverton, UTN736XXMonteiro Aviation LLC · Minneapolis, MNN736XZPiotrowski Anthony J · Nanticoke, PAN736YBCarlson James D · North Andover, MAN736YDTrans World Aircraft LLC · Quakertown, PAN736ZBMunning Gregory T Jr · Greensboro, NCN736ZWBrethren Pa LLC · Pittsburgh, PAN73702Shiles Darrel J · Baltimore, MDN73707Leading Edge Flight Academy LLC · Bend, ORN7370ASunrise Aero Inc · Ocala, FLN7370SNewman Carlon Keith · Cypress, TXN7370TVadakin Jeffrey M · Dover, DEN7370XWilkerson Gale L · Paris, MON7371Registered aircraftN73719Purdue Aviation LLC · West Lafayette, INN7371AArth Richard · Newcomerstown, OHN7371MNagy Meserole Teresa A · Stevensville, MDN7371NBradley Larry · Olustee, OKFirst renewal noticeN7371QHarbor Aviation LLC · Harbor Springs, MIN7371SJacobson Justin D · Fallon, NVN73726Wings Over Texas Holdings LLC · Denton, TXN73727Redtail Partners LLC · Moab, UTN73728Crowe Robert B · Del Valle, TXN7372GSky Cops LLC · Midland, TXN7372HLindholm Michael D · Anchorage, AKN7372MZavala Marco A · Phoenix, AZN73732Midway Capital Aviation Inc · Orlando, FLN73733Muffett Pat D · Eastsound, WAN73734Daro Norman E · Cody, WYN73735Martineau Aircraft Inc · Butte, MTN7373ABaker Thaddeus J · Elk, WAN7373EQuist Donald G · Ridgecrest, CAN7373MFarwell Linda B · Leavenworth, KSN7373NPyne Jeffrey S · Spanish Fork, UTN7373QMidgette Damon · Santa Clarita, CAN7373SSkiles Jere K · Narvon, PAN7373UYr-Aircraft Leasing LLC · Bethel, AKN73742Adams Bruce M · Santa Fe, NMN73744Fca Flight Center Inc · Fitchburg, MAN7374ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN7374DBig E LLC · Lemoore, CAN7374EWings As Eagles Mission Air Service Inc · Oshkosh, WI
Back to AD 79-10-14 R1