AD 90-06-13
Registered aircraft · 1,827
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:90-06-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:90-06-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:90-06-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:90-06-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.
N89MVLegacy Aviation Trust Holdings Corp Trustee · Doral, FLN89PR603 Holdings LLC · Aberdeen, SDN89TJSkywerx Aviation Inc · Blair, NEN8AMMraf LLC · Wilmington, DEN8EBWoodbine Aviation LLC · Lewes, DEN8EFMcco Inc · Tuscumbia, ALN8KBBiddulph Oldsmobile Inc · Phoenix, AZN8NXExecutive Aviation Group Inc · Saint Petersburg, FLN900EN900e LLC · Lewes, DEN900GFShb-Cb LLC · Shreveport, LAN900LMMiller Aviation LLC · West Palm Beach, FLN900PBFlb Group LLC · Knoxville, TNN900PSAero Air Charter Holding LLC · Pensacola, FLN901ABAngel Brothers Enterprises Ltd · Baytown, TXN901BABismarck Air Medical LLC · Bismarck, NDN901FFFlightline Holdings II LLC · New Orleans, LAN901LBNwl Capital Holdings LLC · Black Eagle, MTN901LKBhb7 LLC · Vestavia, ALN901RHBank Of Utah Trustee · Salt Lake City, UTN902FJ & J III LLC · San Antonio, TXN904BBMmw Aviation LLC · Chesapeake, VAN904JJetran LLC · Horseshoe Bay, TXN904LRChrysler Aviation Inc · Van Nuys, CAN904MACjd Air Inc · Sanford, FLN904SJA&M Aviation LLC · Irondale, ALN905LCLoraine LLC · Wilmington, DEN905MHScranton Christian · Walnut Creek, CAN905NDDodson International Parts Inc · Rantoul, KSN9072UN9072u LLC · Ocala, FLN907DBErics Leading Edge Inc · St George, UTN907DFSummit View Aviation LLC · Aurora, ORN909DJCitation N909dj LLC · Palm Beach Gardens, FLN909LBNtbb LLC · Henderson, NVN909SFSayum LLC · Gonzales, CAN90ASVs Air LLC · Atlanta, GAN90JJSurdex Corp · Chesterfield, MON90PTAbnav LLC · Panama City, FLN90WFSomers-Lawson Land & Cattle LLC · Midland, TXN90ZNorthern Jet Inc · Iron Mountain, MIN910DFAbotan Air LLC · Fort Lauderdale, FLN910RBSky Charter LLC · Slidell, LAN910TKThompson Nathan · Boulder, CON910TRDutch Aviation LLC · Perry, IAN911KADavis Aviation DBA · Brandon, MSN912DPVista Services LLC · Madison, WIN913BJLanier Equipment Leasing LLC · Gainesville, GAN914JALake Area Technical College · Watertown, SDN916JRBode Aviation Inc · Albuquerque, NMN917BBTps Air LLC · Pembroke, NCN917GPEpas LLC · Wilmington, DE
Back to AD 90-06-13