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.
N6880WRegistered aircraftN6880ZMayes Brett R · Williams, CAN68810Air-Planes LLC · Soddy Daisy, TNN68812Avcorp Holdings Inc · Jackson, MIN68813Vogt Jeffrey D · Pleasant Grove, CAN68814Spooner Wade G · Donalsonville, GAN68815Skippy Aviation LLC · Bridgeport, PAN68816Mirkovic Alex · Friendswood, TXN6881KTime 2 Fly LLC · Baldwinsville, NYN6881NMorris Michael R · Columbus, OHN6881UElliott James C · Parker, CON6881VCox Colin T · Harbinger, NCN6881WLewis Mark A · Ozark, ALN68820Putz Aeroplanes LLC · Bryan, TXN6882UHoecher Robert T · Anchorage, AKN68837Somes Jason · Newbury Park, CAN6883BSlagle Allen E · Newcastle, WYN6883JRobbins John L · Crossville, TNN6883KDrb Helicopters LLC · Klamath Falls, ORN6883NAj Mooney LLC · Port Saint Lucie, FLN6883SWebb Ronald G · Dickson, TNN6883VHubbell Carl · Crowley, TXN6883ZFoster Gary L · Palmer, AKN68840Federal Aerial Applicators LLC · Wilmington, DEN6884HWings Over Texas Holdings LLC · Denton, TXN6884JHbk Flyers LLC · Alton, ILN6884KWyatt Mary Ellen Personal Representative · Weirsdale, FLN6884NLutes Kent A · Tazewell, TNN6884USheaffer Bruce R Jr · Lititz, PAN6884VVan Dyck Ryan G · Talent, ORN68857Wright Air Service Inc · Fairbanks, AKN68858Betz Tim · Anchorage, AKN6885HRasmussen Stewart · Santa Barbara, CAN6885NPoskevich Douglas · Deland, FLN6885UGranier Bernie C Trustee · Bandera, TXN6885WMiller Andy D · Marana, AZN6886BOhmans Inc · Gillette, WYN6886HParr Larry · Clarksville, TNN6886JFlanders David J · Madison, WIN6886NSibille Keith Curtis · Griffin, GAN6886UN6886u Inc · Tucson, AZN6886WGregory Joshua L · Oxford, MSN68874Hutchison Thomas L · Kimberly, IDN6887NColton Frank Lasusa · Harrisburg, PAN6887UAce Aircraft Leasing Inc · Nazareth, PAN68882Tri-Gear Aviation LLC · Land O Lakes, FLN68883Baker Jack B · Naples, IDN68884Barren Creek LLC · Mardela Springs, MDN6888BVenell Farms Inc · Corvallis, ORN6888DCenter Charles C · Wasilla, AK
Back to AD 90-04-06 R1