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.
N896DFVenture North Aviation LLC · Cloquet, MNN896DLLane David A · Yuba City, CAN896SCHansen Ernest F · Sequim, WAN89702Carter Flygare Inc · Sacramento, CAN8970JAll Tech Machine & Tool Inc · Greenwood, ARN8970VWinding Creek Aviation LLC · Snellville, GAN89718Schad Paul E · Gainesville, TXN8971DThomas James W · Jay, FLN8971JSwearingen Louis S · Summerfield, FLN8971MDixon Gary Lynn II · Ooltewah, TNN8971VGibson Aviation Services LLC · Hudson, WIN8971YLaubscher John E · Cazenovia, NYN89721Propability One LLC · Daytona Beach, FLN8972CBosn Richard O · Scottsbluff, NEN8972DClarke Timothy B · Howard, SDN8972JPascua Jonathan J · Coventry, RIN8972VPearce Michael J · Phoenix, AZN89735N89735 LLC · Stuart, FLN8973CUrbach Jourdan B · Sherman Oaks, CAN8973DSnider Scott E DBA · Turner, MTN8973FAvelan Enterprises Inc · Elm Grove, LAN8973JMuleshoe Flight Club LLC · Muleshoe, TXN8973VOcean Flyers LLC · Chatham, NJN8973YAire Ryder LLC · Roseville, MNN89743Heavy Metal Air LLC · Farmingdale, NYN89753Aerohead Planes LLC · Savannah, GAN8975VMauser James E · Zionsville, PAN8976Bouchard Paul Marcel · Yellville, ARN89764South Aero LLC · Albuquerque, NMN8976CPetruso Rosemary D Co-Trustee · Saint Louis, MON8976DWilliams Aircraft LLC · Anchorage, AKN8976JGreat Plains Aviation LLC · Lincoln, NEN8976RSteenrod Kenneth Allen · Parsons, KSN8976YAfricano Aircraft Management LLC DBA · Chicago, ILN89770Seals Richard W · Torrance, CAN8977DWilliams Aircraft LLC · Anchorage, AKN8977JJohnson Bradley F · West Babylon, NYN8977LSarigul Klijn Nesnn · Dixon, CAN8977RCozine Mark R · Cherokee, IAN89780Huffman Jacob M III · Burleson, TXN8978CMenke Clint A · Cozad, NEN8978DShuman Cecil R Trustee · Chugiak, AKN8979DBurnett Kris W · Anchorage, AKN8979MBean George W Jr · Fort Worth, TXN8979RSeeley Lenard D · Osage, WYN8979VAvel Aircraft Inc · West Chicago, ILN897ALJansky Sand & Gravel Inc · Hallettsville, TXN897DCRed Baron LLC · Middletown, DEN897DSHolliday Richard A · Fort Worth, TXN897ECMatacia Thomas Eugene · Evergreen, NC
Back to AD 90-04-06 R1