AD 90-04-06 R1
Registered aircraft · 68,377
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-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N54VAFisheer Eric E · Memphis, TNN54VCStrahler Mark D · Peachtree City, GAN54VTRegistered aircraftN54VVVoutour Ryan R · Tehachapi, CAN54WEWilson Douglas E · Emporia, KSN54WYBernegger Mark S · West Point, MSN54YEBrown Lonnie S · Lone Jack, MON54ZRPoehlmann Ralph T · Brenham, TXN5500CDuncan Robert L · Greenville, MSN5500GCummings Terence J · Morgan Hill, CAN5500LWinchell Lawrence R · Salem, NJN5500MDecathlon Training Inc · Saint Louis, MON5500UJones Donald T · Barrigada, GUN5500WKansas State University · Salina, KSN5500ZPfc Aviation Repair Inc · Wallingford, CTN55010Royal Aviation Academy LLC · Sarasota, FLN55018Stiver Roger M · Nashville, ARN55019Berry Kirby T · Poolville, TXN5501AProfly LLC · Wichita Falls, TXN5501FWade Joshua Michael · Saline, MIN5501NRoddy Warren D · Skokie, ILN5501WTailwinds Aviation LLC · Kokomo, INN55021Robertson Alan L · Hastings, NEN55023Charron William H · Burwell, NEN55028First Alarm Aviation LLC · Fosters, ALN55029Chandler William John · North Palm Beach, FLN5502AAero Enterprises LLC · Orange, VAN5502CWebb Brad · Ekron, KYN5502HSky View LLC · De Smet, SDN5502MRegistered aircraftN5502QAcademy Computer Services Inc · Stoneham, MAN5502U90 Degree Crosswind LLC · Arcadia, FLN5502WWest Kentucky Wings And Toons LLC · Benton, KYN55030Reiner John G · Wakefield, MIN55033Mcneill James R · Wichita, KSN55034Osceola Aerosport LLC · Osceola, WIN5503AKey Dallas T · Hoover, ALN5503CMccreary William J · Glendale, AZN5503FN5503f Aircraft Holdings LLC · Orangeburg, SCN5503HCp Aviation Inc · Santa Paula, CAN5503JFalterman Patrick J · Cleveland, TXN5503QPrecious Metal Aviation LLC · Menomonee Falls, WIN5503UFuller Christopher Jason · Destin, FLN5503VPurstell Kevin D · Burnt Hills, NYN5503YBundt Benjamin L · Montebello, CAN55041Napier Clarence M · Mount Juliet, TNN55042Rohrbaugh Mark A · Lenexa, KSN55044Yale Aviation Inc · New Haven, CTN5504FWieselquist Kermit L · Westford, MAN5504KWhite Traci Michelle · Manasquan, NJ
Back to AD 90-04-06 R1