AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5114HReints 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, IDN5114ZMustang Sally Aviation LLC · Camden, SCN5115BWateractive43 LLC · Auburn, CAN5115EBarak David T · Mountain Home, IDN5115NFernandez Arriaga Emilio · Miami, FLN5115PSmith 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, ALN51163Christiansen Aviation LLC · Wilmington, DEN5116BQuantum Aviation LLC · Manchester, MDN5116DRoche Patrick R · Wichita Falls, TXN5116HMusgrove Jimmy Wayne · Delta Junction, AKN5116JCarll Elizabeth M · Chicago, ILN5116LLits LLC · Bowling Green, KYN5116RSajdak Brian Christopher · Hernando, MSN5116SWizco Company LLC · Norfolk, NEN5116VWilliams Harry D III · Frostproof, FLN5117DAndre Kashierski · Estill Springs, TNN5117EJav Air Services LLC · Anchorage, AKN5117LEmery Jonathan D · Payson, AZN5117PMarsteller Michael A · Lugoff, SCN5117QBush Thomas D Jr · Cypress, TXN5117TLevitan Sergei · Hollywood, FLN5117WJorgensen-Tjorneho Erik R · Conroe, TXN5118HDavis John C · Anchorage, AKN5118PMeng Marvin Allen Jr · Edwardsville, ILN51198Registered aircraftN5119HChenoweth Tucker T · Talkeetna, AKN5119PWood John W · Toccoa, GAN5119UClark Christopher F · Boise, IDN5119WLe Thanh Q · Santa Ana, CAN5119XMission Aviation Fellowship · Nampa, IDN511AGIc Johnson LLC · Belton, SCN511BSMurphy David G · Apalachin, NYN511CMartin Gary N · Lake Jackson, TXN511CFFendler Michael J · Pittsfield, MEN511CWSydow Daniel P · Duluth, MNN511DCJago River Holdings LLC · Fairbanks, AKN511DFKma Aviation LLC · Phoenix, AZ
Back to AD 2007-04-19 R1