AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N3411XLo Lo Aviation Inc · Wilmington, DEN3411YFinnelly Barry J · Snohomish, WAN3411ZBurroughs Garwin M · Yuma, AZN34121Downey Colin T · Jupiter, FLN34122Cardinal Flying Club LLC · Saint Helens, ORN34125Quinones Horacio Adan Gil · Palmdale, CAN34129Shook Mitchell M · Vidalia, GAN3412CWilson Steve D · Sentinel, OKN3412FClaretta Inc · Wilmington, DEN3412QPoulsen Melvin J · Orem, UTN3412SBanks Ramona C · Huntsville, ALN3412TC177knotclub LLC · Springfield, ILN3412WN3412w LLC · Lithia, FLN3412YSkinner Jason Richard · Templeton, CAN3412ZBeck Gary E · Richlands, NCN34133Geneva Lakes Flying LLC · Bristol, WIN34138Wheat Michael D · Wichita Falls, TXN34139Registered aircraftN3413KRogers Howard M · Douglasville, GAN3413SFly Buddies LLC · Tucson, AZN3413XAll Her Fault LLC · Fairbanks, AKN34146Aegis Aero LLC · Vancleave, MSN34147Ferguson Claudia K Trustee · Orange, CAN34148Rupp Gregory J · Deltona, FLN34149Juniper Ventures LLC · Missoula, MTN3414RDanninger James · Kirkland, WAN3414TKkk Services Inc · Saint Charles, MON3414WIrby Almous · Enterprise, ALN3414XMoore Jason E E · Tomball, TXN3414ZPulliam Anthony L · Lancaster, CAN34150Mcalindon Timothy E · Arlington, MAN34153Furness Donald Craig · Pottsboro, TXN34154Sepko Joseph M III · Carrollton, TXN34156King Gregory J · Friday Harbor, WAN3415FGriffith John M · Seatac, WAN3415SLehrkamp Michael C · Caputa, SDFirst renewal noticeN3415WSutton Aircraft Salvage LLC · Palmer, AKN3415XHackford Dalton Decory · Vernal, UTN34162Bowie Kwame James · Fort Lauderdale, FLN34163Middleton Aviation Associates LLC · Madison, WIN34164Quintal Anthony L · Imperial Beach, CAN34166Seamster Gregory L · Ephrata, PAN34167Nichols Kevin R · Chesterfield, MON3416QJaouen Dominique · Berlin, CTN3416SClancey Joseph A · Wake Forest, NCN3416YFlying D Farm Inc · Kerhonkson, NYN3417DJohnson Shawn G · Georgetown, KYFirst renewal noticeN3417GDemark Aviation Inc · Wilmington, DEN3417HGc Monitoring Inc · Bellevue, WAN3417QGholami Amir H · Santa Rosa, CA
Back to AD 2007-04-19 R1