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.
N5213RSoco Aero Leasing LLC · Santa Rosa, CAN5213THess Garrett J · Fullerton, CAN5213WN5213w LLC · Clarksville, TNN5213XSutton Aircraft Salvage LLC · Palmer, AKN5214BCummings Arnold L · Brownsville, CAN5214HVagabond Flight Corporation · Decatur, ILN5214MS & M LLC · Nauvoo, ALN5214XHaltmann Sven · Fairbanks, AKN52152Schmidt Michael D · Windermere, FLN52154Fairfax Stephen A · Johnson City, TXN52156Rbl Missions LLC · Newcastle, CAN5215DAviation Trust Co LLC Trustee · Oklahoma City, OKN5215EWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN5215HDavis Ted E · Brodhead, WIN5215LMorehouse William S · Tucson, AZN5215TBarr Perry L · Bethel, AKN5215WBurns Arlen B · Bellingham, WAN5215XTilghman Glen A · Houston, AKN52160G & M Aircraft Inc · Wheat Ridge, CON52161Odea James D · Oxford, MIN52167Vajtay Catherine · Englewood Cliffs, NJN52168Jin Jin Aviation LLC · Anchorage, AKN5216HWatkins John W · Somers, CTN5216MChu Philip · Surprise, AZN5216TKntl Enterprises LLC · Boise, IDN5216VDeener Larry C · Lexington, KYN5216WSteed Moroni W · Moorcroft, WYN52177Lundahl Frederick · Langley, WAN5217DOptima Aviation LLC DBA · Lewisville, TXN5217HB&R Aircraft LLC · Wadsworth, OHN5217LKenny Tommy D · Maryville, MON5217TJahangiri Ali · Arlington, TXN5217WS B Enterprise LLC · Marshall, TXN52188De Aviation Inc · La Porte, TXN5218GMarlowe James D · Genoa, OHN5218LTjossem James · Thompsons Station, TNN5218QRoberson J R · Mabank, TXN52190Vass Gal Alex D · Merrimack, NHN52195Cabane Marcelo J · Miami, FLN5219JUpham David E · Madison, WIN5219LShanley William D · Orland Park, ILN5219RCoston Mace C · Maryville, MON5219URuryk Jonathan D · Pineville, LAFirst renewal noticeN5219XBlack Mark A · Lawsonville, NCN5219ZGarrett Joe · Saint Jacob, ILN521CBHodge Cleo U · St Thomas, VIN521CWCentral Washington Univ · Ellensburg, WAN521DDUrbana Aviation LLC · Woodstock, OHN521DHPenner Ford Aviation LLC · Lebanon, MON521DMAllison James R · Middlefield, OH
Back to AD 90-04-06 R1