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.
N601LANicely Juan · Mount Vernon, KYN601LPMorford Leon R · Rockford, ILN601MLMahaney James C · Ellijay, GAN601PAMendenhall Michael L · Douglasville, GAN601PSCastle Rock Services LLC · Helena, MTN601RDPichon Dean M · Essex, VTN601RKNorthampton Aeronautics Inc · Northampton, MAN601RVFly Right LLC · Reno, NVN601TGKenmore Crew Leasing Inc · Bellingham, WAN601TMMims Edwin T · Murphy, NCN601VLBeal Mark E · Northwood, IAN601VSJireh Wings LLC · Las Vegas, NVN601VVBilodeau Allan M · Lakeland, FLN601XSSpainhower Craig · Lakeland, FLN6020DDufreche David S · Sanger, TXN6020LJenkins David B · Hemet, CAN6020PClark Katherine A · Spring, TXN6020QN6020q LLC · Jensen Beach, FLN6020WBritton Jeffrey A · Accident, MDN60216Shore Stephen A · Elkin, NCN6021QR&L Aviation Inc · Philadelphia, PAN6021WA&C Aviation LLC · Lawrenceville, GAN6021ZAerial Banners Inc · Pembroke Pines, FLN6022LIrving Donald J · Deland, FLN6022PRegistered aircraftN6022SAhlberg Merick D · Eagle River, AKN6022WDelgado Mario J · Baldwin Park, CAN6023DBusta Daniel N · Los Angeles, CAN6023XSytsma Douglas A · Canton, MIN60244Ace Of Spades Aviation LLC · Las Vegas, NVN6024DPunt Matthew L · Wasilla, AKN6024WWhite Pelican LLC · Union City, TNN60250Camelot Aviation LLC · Wilmington, DEN6025WSocal Flights LLC · Simi Valley, CAN6026GAce Pdr LLC · Lewisville, TXN6026LDolan Kathleen M · Sunnyside, WAN6026QKosmata Charles C · Mcpherson, KSN6027DSnyder Logan J · Wasilla, AKN6027QBergh Robert P · Hammett, IDN6028CPopejoy Gregory M · Sacramento, CAN6028QSky Partners LLC · Sylacauga, ALN6028XHarnagel Duard R · Scottsdale, AZN6029DRonnie L Tremain · Sherwood, ORN6029QHill John T · Saint Augustine, FLN6029WWalsh Robert D · Somerset, CAN602AKimberlin Lisa · San Francisco, CAN602CBWray David A · Louisville, KYN602EPJones Theodore R · Prospect, KYN602FLRoberts David R · West Newton, MAN602FTFlorida Institute Of Technology · Melbourne, FL
Back to AD 90-04-06 R1