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.
N90913Prime Travis R · Hammonton, NJN90915Cnj Flying Inc · Flossmoor, ILN90919Allman Joseph S · Blackstone, VAN9091DCanton Logan J · Petersburg, AKN9091HCampbell Raymond · Box Elder, SDN9091LAmelia Reid Aviation LLC · San Jose, CAN9091VScheutzow David P · Medina, OHN9091YCsa Investments LLC · Wayne, PAN90922Blair Ernest J · St Thomas, NDN90923Gravesen Mark A · Kenmare, NDN90928Skunberg Leonard T · Salmon, IDN9092HWinemiller Stevie Dale · Swifton, ARN9092JRegistered aircraftN9092LYoung Vernon P · Metter, GAN9092RSmith Michael A · The Villages, FLN9092VHogan Roger C · Virginia Beach, VAN9092WLong Earl V III DBA · Wichita, KSN9093Zimsim LLC · Charleston, SCN90931Davies Donald K · Hastings, MNN90932Hall Air Inc · Weiner, ARN9093FArcher 93f LLC · Danvers, MAN9093JRichardson Harley T Jr · Mullins, SCN9093KPdg Leasing LLC · Maryland Heights, MON9093LBielamowicz John Kolbe · Waxahachie, TXN9093SEllis Derek J · Austin, MNN9093TScotts Helicopter Services Inc · Le Sueur, MNN9093ZCloud Niner LLC · Furlong, PAN90943Center Of Gravity LLC · Elmira, NYN90945Pennison Scott J · Nikiski, AKN90947Macleod Andrew S Trustee · Anchorage, AKN90948Ccf Ventures Inc · Bangor, MEN9094JDagny Aviation LLC · Gardendale, TXN9094KWomack-Kalla Dennis E · Philadelphia, PAN90957Cubcrawlers LLC · Cocoa, FLN90963Bloom Wade D · Eagle, IDN90964Mccone Malcolm F · Wasilla, AKN90965Guinn Gary L · Tulsa, OKN90966Poultry Not Beef LLC · Chancellor, ALN90967Bollinger Bruce W · Grove City, PAN90968Petrie Robert J · Eagleville, TNN90969Trinity Aire LLC · Drakesville, IAN9096DHenderson Richard J · Fairbanks, AKN9096HCallaway Mary Ann · Homedale, IDN9096JWingsleasing LLC · Wichita, KSN9096TBassett Donald · Ashford, ALN90970Darr Realty LLC · Cozad, NEN90971Solsvig Jason A · Wasilla, AKN90973Skydive Santa Barbara LLC · Lompoc, CAN90974Pruszenski Jordan M · Anchorage, AKN90975Schiestle Jason · Greenville, PA
Back to AD 90-04-06 R1