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.
N39SJArrigo Johnathan T · Mill Spring, NCN39SKJustman Robert A · Cotati, CAN39TBAlibi Flying Club · Bakersfield, CAN39TSMiller William L · Williamson, GAN39WDWilliams Ryan P · Calera, OKN39XPMason Samuel · Santa Paula, CAN39YBWeaver Brian R · Crossville, TNN3AAJones Stephen C · Wadsworth, ILN3ACMaurer Christian N · Loveland, OHN3AKSantana Barry W · Wasilla, AKN3AMBeavers William W · Bear Creek, NCFirst renewal noticeN3ARMatejczyk Daniel E · West Hills, CAFirst renewal noticeN3BNHansen Warren K · Bozeman, MTN3BYJamora Daniel L · Victorville, CAN3CLWehner Kaitlyn M · Malone, WIN3DCPurpose Flight Inc · Wilmington, DEN3DNNodorft Daniel F · Orlando, FLN3DTBighorn Flying Company LLC · Wood River, NEN3DYRegistered aircraftN3ECLindsey John T · Blue Earth, MNN3FHScarborough Alex C · Lubbock, TXN3GMeloche Michael S Trustee · Hamilton, MTN3GFRhoads Timothy C · Logan, NMN3GPAerospace Museum Of California · Mcclellan, CAFirst renewal noticeN3GVLong Michael L · Pendleton, INN3HCOvans Ronald J · Birchwood, WIN3HXWreyford James S · Marble Falls, TXN3JARegistered aircraftN3JKPagenkopf Joseph C · Juneau, AKN3KBJobe Dwaine B · Chilhowee, MON3KEBlevins Myrl Dean · Wytheville, VAN3KMStevens Burton G · Las Vegas, NVN3KVAirmax Charters LLC · Lake Worth, FLN3LCStimson Andrew J · Battle Ground, WAN3LYBurkey Jeffery C · Stuart, FLN3MKRedwing Aviation LLC · San Antonio, TXN3MSCarter Zac · Atlanta, GAN3MVVia Mikael W · Camarillo, CAN3MWDantonio David · Wichita Falls, TXN3NOlson Ventures LLC · Golovin, AKN3NEPatton Ronald V · Marion, TXN3NLBaez Rafael · Stafford, VAN3NUNystrom John L Jr · Albuquerque, NMN3NYRegistration Pending · Ponte Vedra, FLRegistration pending, pending cancellationN3PLCarlin Bernard T III · Norman, OKN3QRKittridge Gordon · East Corinth, VTN3QTNew World Enterprises Inc · Aiken, SCN3QWPorterfield Bruce A · Reno, NVN3RQAir Carriage Inc · Chico, CAN3RWGordon George M Jr · Weston, MA
Back to AD 90-04-06 R1