AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N2224J24j LLC · Driggs, IDN2224XRegistered aircraftN22250Rush Christopher C · Anchorage, AKN22251Barber Michael L · Igo, CAN22252Heid Nathan E · Nevada, OHN22253Blue Sky Investments LLC · Fayetteville, NCN22255Rodcon Aircraft Sales LLC · Kalispell, MTN2225EQuad City Area Flying Eagles Inc · Milan, ILN2225TBunger Richard E · Spring Branch, TXN22260Arnold James R · Latrobe, PAN2226SE S P Aviation LLC · Wilmington, DEN2226YRamjattan Enarl A · Harahan, LAN22271Ps N22271 LLC · Green Bay, WIN22276Ramsey Lenny J · Greeneville, TNN22277Gage Rodney L · Oak Grove, ARN2227YAdam Lewis W · Chiefland, FLN22284Fenton Ted P · Rushville, MON22285Barlow Richard B · Stockbridge, GAN2228GHalo Halo LLC · Milwaukie, ORN2228SHannaford Edward M · Roseville, MIN22297Trissell Flying Service Inc. · Clarksville, TXN2229CYleski LLC · Bozeman, MTN2229ESix Pack Aviation LLC · Pocono Pines, PAN2229SKey Lime Consultants LLC · Wilmington, DEN2229XByers Gary F · Wasilla, AKN222AKChambers Samuel S · Salmon, IDN222ATSierra 1 Tech Inc · Blue Jay, CAN222AWJust Planes Inc · Hobbs, NMFirst renewal noticeN222AXGraven Timothy G · Foristell, MON222BJFlight Smith LLC · Orem, UTN222BKDeralex Airways LLC · Miami, FLN222BVBb Air LLC · Chesapeake, VAN222CTMorency Richard · Houston, TXN222ERGjg Air LLC · Amarillo, TXN222ETValiair Lc Trustee · Casper, WYN222FDKent State University · Stow, OHN222FFReagan John · Knippa, TXN222FGSkytravel LLC · Victoria, TXN222HERound Engine Aero · Nashville, MIN222HPHarrison Walter E · Taylor, TXN222JHRegistered aircraftN222LJDodson International Parts Inc · Rantoul, KSN222LSLj Bickford Companies LLC · Wasilla, AKN222MHJones Jimmy N · Bremond, TXN222NYCivil Air Patrol · Maxwell Afb, ALN222PAFrank Eric A · East Troy, WIN222PEPacific Air Charters Inc · Honolulu, HIN222PFStokes Brian L · Boulder City, NVN222PLAnderas Per R · Green Bay, WIN222PRFlying South LLC · Wilmington, DE
Back to AD 97-01-13