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.
N8894JMenees B Martin · Little Rock, ARN8894VBeckworth Brad T · Jacksonville, FLN8895JCherokee N8895j Inc · Westminster, MDN8895NLuque Michael J · Shinnston, WVN8895YRegistered aircraftN8896Ausbun Taylor J · North Pole, AKN8896DGidzinski David A · Weirsdale, FLN8896EN8896e LLC · Lake City, FLN8896JClark Kenneth A · Mount Pleasant, ARN8897JShreve Gene · Fayetteville, TNN8897NAnderson Leroy H · San Angelo, TXN8897YAvion LLC · Lewes, DEN8898DWelty Donald Robert Jr · Glennallen, AKN8898JColt 45 LLC · Tulsa, OKN8898NTaylor Danny H · Defuniak Springs, FLN8898YWickenheiser Kenneth W · Sun City, AZN8899ERgp Aviation LLC · Wilmington, DEN8899LSujet Dylan P · Hampton, NJN8899YSture Joel M · Anchorage, AKN889DQualitair LLC Trustee · MichelstadtN889DALeik Aviation LLC · Dousman, WIN889FNe Ia Helicopter LLC · Tekamah, NEN889GSKlock Dexter F · Driggs, IDN889MSturza Allen J · Boyne City, MIN889MHExtreme Helicopter Service LLC · Alice, TXN889RMSands Kevin A · North Chili, NYN889SCCrawford Stevan L · Woodinville, WAN889TJvs LLC · Santa Rosa, CAN88ABBrown James L · Athens, ALN88ACSegerstrom William C · Sunriver, ORN88AHScott Cody · Eagle, CON88AKState Of Alaska · Anchorage, AKN88ALChristenson Lloyd Gregory · Side Lake, MNN88APLangdon Brian B · Newcastle, WAN88ARLumley William B · Delray Beach, FLN88BELee George M · Queen City, TXN88BSBachman Jared R S · Elbert, CON88BWRegistered aircraftN88CFWoodford William Boyd · Superior, MTN88CTCameron John W · Canby, ORN88CVAllen David L · Sturgis, SDN88DEMatta Figueroa Eduardo · Chapman, KSN88DRAkerson Charles J · Clarksville, TNN88EStarlite Aviation Technologies LLC · Las Vegas, NVN88EFPeyton Craig L · Rhinebeck, NYN88EHSale Reported · Pismo Beach, CASale reported, pending cancellationN88ETGelfan Russell A · Bellingham, WAN88FCSandlapper Aviation Of De Inc · Bennington, VTN88FNSaline County Flyers Association LLC · Little Rock, ARN88FRAero Solutions Inc · Henderson, NV
Back to AD 90-04-06 R1