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.
N6899FLevel Up Aviation LLC · Newton, ALN6899NStearns Lloyd Bernard · Georgetown, TXN6899UMayo Clayton E · Ten Mile, TNN689AW Grotendiek LLC · Portland, ORN689BTDoell Brad J · Elsie, NEN689ENafsinger Nicholas A · Rosharon, TXN689HSTexxon Resources Inc · Winter Park, FLFirst renewal noticeN689LHChristiansen Aviation LLC · Wilmington, DEN689MAN28179 Inc · West Gilgo Beach, NYN689NDUnd Aerospace Foundation · Grand Forks, NDN68ACSchgallis Richard J · Gainesville, VAN68ADMorgan Edward J · Murchison, TXN68AGDelucia Dennis DBA · Franklin, PAExpired dealer, pending cancellationN68AH740 Assoc Inc · Wilmington, DEN68BAllen April E · Green Cove Springs, FLN68BDBuiqui Aerospace Corp · Kissimmee, FLN68BLPhillipson Justin M · Vacaville, CAN68BWRegistered aircraftN68CNEichten Steve G · Colleyville, TXN68CSTrojen Properties LLC · Joplin, MON68DBLai LLC · Flowood, MSN68DEMazzoni Dennis · Mays Landing, NJN68DGDellar Randy Roger · Wasilla, AKN68DWAero Group I LLC · Woodstock, VAN68EEBurtt John B · Pierson, MIN68FSistrunk Donald M · Ragley, LAN68GJDc Foote & Associates Inc · Camarillo, CAN68GPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN68HKPomeroy Andy Lee · Seattle, WAN68JCCapps Jon T · Bentonville, ARN68JJRegistration Pending · N Richlnd Hls, TXRegistration pendingN68JXRybarczyk Thomas B · Benton, KSN68JYHowell Jon · Texarkana, ARN68KAAakre Keith E · Granite Falls, MNN68KBKeller Bros Airport Inc · Lebanon, PAN68KFDelconte Anthony T · Old Hickory, TNN68KTHobein Ted · Wheaton, ILN68LCDriver Matthew · Rio Rancho, NMN68LHGottschall James W · Highland, WIN68LKKing Larry E Jr · Wenatchee, WAN68LRMs Aero Inc · Lakeville, OHN68MABig Creek Flyers LLC · Lewes, DEN68MCAlpha Enterprises · Burley, IDN68MEPeigneux Brothers Llp · Malta, MTN68MHScott Jerry E · Houston, TXN68NDSand Nicholas Patrick · Alta, IAN68PJOdonnell Paul E · Schuylerville, NYN68PVAircraft Guaranty Corp Trustee · Oklahoma City, OKN68QCobb Lee C · Van Alstyne, TXN68RLeroy Philippe G · Willcox, AZ
Back to AD 90-04-06 R1