AD 81-13-10 R1
Registered aircraft · 4,001
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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.
N61846Wood James P · Greenbank, WAN6192KSmith Chris Sean · Pendleton, SCN6194HJones Frederick W · Burgaw, NCN619BPGay Brandon W · Campbellsville, KYN619DCHarvard Air Taxi LLC · Andover, MAN619DT6 Dt Flyers LLC · Corpus Christi, TXN61ABj Aviation LLC · Beaver Meadows, PAN61DPDjp Enterprises Inc · Chandler, TXN61HBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN61LMBowling Realty Inc · Jackson, MSN62003Valpey R Wesley Jr · Medford, MEN62015Bender Evan D H · Linville, VAN62034Williams Robert W · Anchorage, AKN62037Martin Terence R · Newport, ORN62039Schuerman William R · Arlington, WAN62040Comm William · Mulino, ORN62043Hardy John R · Wasilla, AKN62044Pentz Geoff M · Port Ludlow, WAN62045Lewis John R · Juneau, AKN62051Anderson John · El Paso, TXN62062Atlas Air LLC · Salt Lake City, UTN62063Harrison Kelcey A · Galena, AKN62066Whitfield Timothy D · Fairfield, NCN62067Cole Matthew M · San Jose, CAN62070Wydra Richard J Jr · Mchenry, ILN6207NAdvanced Sport Psychology LLC · Orlando, FLN621EDPhantom Aviation LLC · Ormond Beach, FLN621LGAdams Aviation Services Inc Trustee · Wilmington, DEN6220FHeberle David B · Castroville, TXN62217Wieken Peter J · Mount Joy, PAN6226Lewis Jay C · Spanaway, WAN6228FLynch Kent · Edwards, ILN623WCWilkinson Craig R · Parker, AZN6241CK&M Aviation LLC · Kemah, TXN6243FReim Rodney D · Enid, OKN6243KAerospace Trust Management LLC Trustee · Wilmington, DEN6244FRegistered aircraftN6245FCosse Harold C · Euless, TXN6246FCsc Delaware Trust Co Trustee · Wilmington, DEN6248FStevenson David E · Grundy, VAN624KRSafe Charter Inc · Bethesda, MDN6250FNeeper Philip A · Fayetteville, NCN6263CKasallis Thomas G · Midlothian, TXN6267FSkymaster Company LLC · Dover, DEN626FMN626fm LLC · Brunswick, GAN626WAZarlenga And Seltzer Inc · Palmyra, PAN6276FHubler Bruce F · Caldwell, IDN627FDPacific Health Care Staffing Inc · Rancho Cucamonga, CAN6284FMathews Wade A · Wichita Falls, TXN6288FAircraft Leasing And Service · Malabar, FL
Back to AD 81-13-10 R1