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.
N5738UFlorida Time Building LLC · Port Saint Lucie, FLN5738WCherokee 38whiskey LLC · Charlotte, NCN57390Beyer Mark E · Towanda, KSN57394Mccombs Evan · Peyton, CON57395Zangs William J · Poplar Grove, ILN57399Aerobatic 8kcab Holdings LLC · Murchison, TXN5739DSmith James A · Lyle, WAN5739HRegistered aircraftN5739LMcgll Phil · Huntsville, ALN5739QMorell Timothy S · Lino Lakes, MNN5739WFeralova Erika H · Gresham, ORN573ATAtp Aircraft 3 LLC · Wilmington, DEN573CBMussell Lincoln D · Longview, TXN573ELStellaire Alliance LLC · Fort Worth, TXN573JAYale Companies LLC DBA · Fishers, INN573MBWigley Barry L · Langston, ALN573MWWhelan Company LLC · Hoover, ALN573SMason Scott C · Lebanon, ORN573TMFarley Douglas C · Edmond, OKN57401Adams Kenneth · Marana, AZN57404Cp Aviation Inc · Santa Paula, CAN57405Shoaf Douglas G · Lake Oswego, ORN57407Britt Elaine L · Locust Grove, GAN57408Phillips Thomas G · Fairbanks, AKN5740HPritchett Michael L · Benton, ARN5740QOasis Aero Inc · Willmar, MNN5740UBraden Daniel · Port Charlotte, FLN5740WAdams Clay · Anacortes, WAN5740ZLashley Chad P · Wentzville, MON57410Eddy William Crawford III · Sugar Hill, GAN57411Gregory Larry C Trustee · Farmington, MON57412North County Flight Training Inc · Carlsbad, CAN57413Miller Sybille A · Ashburn, VAN5741DJ&H Sewing & Vacuum Inc · Soldotna, AKN5741FBrower Alan L · Califon, NJN5741LWienclaw David E · Boise, IDN5741WGonzalez Jose M · Arlington, TXN57420Florida Man Aviation LLC · Saint Petersburg, FLN57421Snider Roger A · Harlem, MTN57422Heefner Frederick C · Greencastle, PAN57423Pardue Roy S · Clifton, VAN57424Wood Flying Inc · Panhandle, TXN57428Zygomalas Stefanos · San Francisco, CAN5742DHemminger Blair · Gwinner, NDN5742LGjorvad Steven A · Punta Gorda, FLN5742UAdams Sara · Leavenworth, KSN5742WJohnson Ronald H · Goodlettsville, TNN5742ZBootz Terry A · Canyon Lake, TXN57430Swanson Michael D · Council Bluffs, IAN57433Propwash LLC · Princeville, IL
Back to AD 90-04-06 R1