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.
N87WAMann Ronald L · Pound Ridge, NYN87WBWild Bitch LLC · Oklahoma City, OKN87WHPerry Larry B · Montross, VAN87WJKrueger Kenneth L · Newberg, ORN87WRJohnston Donald C · Davis, CAN87XPSutherland Brian · Nolensville, TNN8800JRobinson Jacob · Lewistown, MTN8800YAlexander City Aviation Corp · Alexander City, ALN8801CBlue Chip Aviation LLC · Falling Waters, WVN8801MStein Bruce A · Punta Gorda, FLN8802Osterberg Douglas · Neenah, WIN8802FMc Lane Jonathan T · Morrisville, NCRevoked, canceledN8802JShivers James C II · Columbus, OHN8803Lindsay Lori K · Kenai, AKN88037Willke Sue E · Sewickley, PAN88038Quirk Charles L · Lake Charles, LAN88039Chapman Jeffrey C · Brownsburg, INN8803DWhite Jacob · Soldotna, AKN8803FAg Helicopters Inc · Ft Collins, CORegistration revokedN8804Hail Jerry D · Keatchie, LAN88047Rjr Airdrome Inc · Dover, DEN8804NCarbon Regional Aero Club · Lehighton, PAN8804PJohnsen Christian · Lake Havasu City, AZN8804YMartino Aviation LLC · Wilmington, DEN88055Lake Air Academy LLC · Richland, MIN88057Registered aircraftN88059Tidewater Soaring Society · Windsor, VAN8805CSandifer Steve R · Barnwell, SCN8806Loyd Robert Oliver Parke · Wallingford, KYN88063Evenson Gabriel J · Fargo, NDN88065Obx Airplanes LLC · Manteo, NCN88066Nightingale Patrick R · Lakewood, CAN8806CGribbins Aviation LLC · Campbellsville, KYN8806JLytle Hugh R · Senoia, GAN8806NHorne Terry A · Carefree, AZN8807Potter David · Huntley, ILN88078Khm Investments Inc · Lehi, UTN88079East Hill Flying Club Inc · Ithaca, NYN8807DGorski Tim B · Larsen, WIN8807JNorris Dana G III · Zanesville, OHN8807NTruax James D · Roanoke, INN8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJN88081Butler Julie L · Los Osos, CAN88083N3542w Inc · Wilmington, DEN88085Poulson Daniel J · Anchorage, AKN88086Saliba Eric · Mineola, NYN8808DDwight Thomas W · Castalia, OHN8808JCoulliette Brian K · Jacksonville, FLN8808YAukes Brian E · Huxley, IAN8809Velociraptor Aviation LLC · Toney, AL
Back to AD 90-04-06 R1