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.
N5113QTri-County Aviation LLC · Lawrenceburg, TNN5113RHamaker Nevada C · Bothell, WAN5113TSchaffner David A · Wray, CON5113XHemstock Ronn · Seward, AKN5113ZNielsen Jeffrey L · Harlan, IAN5114HReints Rydell J · Wasilla, AKN5114KParrillo Development And Real Estate LLC · Moorestown, NJN5114LHenry Lawrence D · Lohman, MON5114PParris David T · Virginia Beach, VAN5114RHayden Steven E · Westminster, CON5114SConner W Larry · Los Lunas, NMN5114THarlan Robert J · Kaycee, WYN5114USilverhawk Aviation Academy LLC · Caldwell, IDN5115EBarak David T · Mountain Home, IDN5115PSmith James Kelly · Newark, OHN5115RMichael D Woods LLC · Harleton, TXN5115SBridgeport Flying Club LLC · Bridgeport, CAN5115TTurkey Creek Aviation And Helicopter Service LLC · Uvalde, TXN5115UFournier Marc A · Jean, NVN5115VGruber Thomas · Seattle, WAN5115XArbaczauskas Stanislaus · Daphne, ALN5115ZSager Charles J Jr · Wofford Heights, CAN5116BQuantum Aviation LLC · Manchester, MDN5116HMusgrove Jimmy Wayne · Delta Junction, AKN5116JCarll Elizabeth M · Chicago, ILN5116LLits LLC · Bowling Green, KYN5116QAvolant Aviation LLC · Mooresville, NCN5116RSajdak Brian Christopher · Hernando, MSN5116SWizco Company LLC · Norfolk, NEN5116VWilliams Harry D III · Frostproof, FLN5117EJav Air Services LLC · Anchorage, AKN5117LEmery Jonathan D · Payson, AZN5117PMarsteller Michael A · Lugoff, SCN5117QBush Thomas D Jr · Cypress, TXN5117WJorgensen-Tjorneho Erik R · Conroe, TXN5117ZWroe Daniel · Denton, MDN5118HDavis John C · Anchorage, AKN5118ZToner Phillip A · Devine, TXN5119HChenoweth Tucker T · Talkeetna, AKN5119PWood John W · Toccoa, GAN5119TAmelia Reid Aviation LLC · San Jose, CAN5119WLe Thanh Q · Santa Ana, CAN511BSMurphy David G · Apalachin, NYN511CEWesolowski Chris E · Anchorage, AKN511DMCapron Robert S · Seneca, SCN511FTLatorre Bruce · Ferndale, CAN511GKAir Devices Company LLC · Alpena, MIN511GLFrerichs Brent A · Sandpoint, IDN511JHRiester Bernard J Jr · Auburn, NYN511JKParcel Stephen · Franklin, NC
Back to AD 90-04-06 R1