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.
N6112WRoberts Jackie P · Bangs, TXN6113JOracle Aviation LLC · Omaha, NEN6113LBonilla Neftali H · Krum, TXN6113NKrabill Ronald D · Halsey, ORN6113RColorado Northwestern Community College · Rangely, CON6113VLegacy Lsa LLC · Plainview, TXN6113WMurray Brian C · Jonesboro, ARN6114NSabourin David R · Draper, UTN6114WGottschalk William R · Fort Atkinson, WIN6114YFlies Warren E · Mesa, AZN6115Woxof Corp · Wilmington, DEN6115DGeske Robert L · Enderlin, NDN6115LWhite David W · South Fulton, TNFirst renewal noticeN6116Historic Aircraft Restoration Museum · Saint Louis, MON6116JGlobal Technical Services Inc · Fort Worth, TXN6116WKlyder Thomas A · Inverness, FLN6117LFlight Tech Inc · Arlington, WAN6117MFayette Hawks Flying Club Inc · Somerville, TNN6117PFriesen Aiden · Grants Pass, ORN6117WRoesler Robert D · Gordonsville, VAN6118DAtkinson James A · Bouse, AZN6118FPlane Fun Inc Tr Trustee · Snellville, GAN6118WPiekielek John L · Punxsutawney, PAN6119DMeyer Robert M · Lancaster, NYN6119L19lima LLC · Elkhart, INN6119PModisette Jeremy W · Baldwin, GAN611ALMaverick Management Montana LLC · Yarmouth Port, MAN611APDobry Robert S · Crescent City, FLN611BDClement Aviation Inc · Tea, SDN611BRKnick Michael J · Camarillo, CAN611CAWilliams Todd A · Littleton, CON611DMFildes Robert · Troy, MON611DRK & A Solutions LLC · Summerfield, NCN611DXRegistered aircraftN611EAEndeavour Flight Training Inc · Opa Locka, FLN611EVAero Activities LLC · Edgewood, NMN611FLZipp Nicole E · Raleigh, NCN611FTCoco Aircraft Inc · Merritt Island, FLN611JBBlanton Jeff H · Sacramento, CAN611JPAerospace Trust Management LLC Trustee · Wilmington, DEN611KJArmstrong John G · Colorado Springs, CON611MHAwesome Aero LLC · South Plainfield, NJN611RCCutbirth Henry R · Monahans, TXN611RVNelson Miles · Corvallis, ORN611SCFf22 LLC · Scottsdale, AZN611SEGo Suborbitals LLC · Los Altos, CAN611VMCavender Jake Scott · Jacksonville, FLN611VWAlley Mark Z · Cedar City, UTN611WKSharpe William L · Bushnell, FLN6120ABrabeck Mark F · Glasgow, MT
Back to AD 90-04-06 R1