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.
N282PHMission Padamo Aviation And Support Inc · Luray, VAN282RTenere Ventures LLC · Wilmington, DEN282RCCardwell Ronald L · Littleton, CON282RDRonneberg Devin H · Molalla, ORN282RFDevault Michael E · Fairmont, WVN282SHBubs Leasing LLC · West Des Moines, IAN282TWLake Of The Woods Aviation LLC · Baudette, MNN282VKelly Michael J · Overgaard, AZN28301Breault John L III · Los Angeles, CAN28302Larson Barry S · Loomis, CAN28303Elshire Vance M · Newberry, FLN28304Conard Isaac J · Overland Park, KSN28306Tiger Flyers Inc · Santa Monica, CAN28307Dfix LLC · Parker, CON28309Hesoun Jeffrey J · Surgoinsville, TNN2830AMarathon Heater Inc · Del Rio, TXN2830JPagano Nathan J · New Haven, CTN2830PSandpiper Aviation LLC · Wilmington, DEN2830QRetro Modern Aviation LLC · Manitou Springs, CON2830RCae Flying Club Of Ohio · Toledo, OHN2830TThree Zero Tango Corporation · Wentzville, MON2830XCollins Stanley T · Elizabethtown, KYN28316Rmp LLC · Pocatello, IDN2831GJohnston Skippy W · Fairbanks, AKN2831KBjorkman Glenn A · Goleta, CAN2831TMesiemore Roger · Lake Wylie, SCN28320James Allan L · Eloy, AZN28328Plein Lindsay E · Wrightwood, CAN2832MCronin Terrance F · Federal Way, WAN2832RMabe Bradley L · Cascade, IDN2832TKirtland Air Force Base Aero Club · Kirtland Afb, NMN28330Neumayer Barry A · Redlands, CAN28331Samoskevich Stephen A · Trumbull, CTN28335Vance Marc G · Canal Winchester, OHN28336Kittenplan Alex H · Millbury, MAN28338Registered aircraftN28339St Laurence Perry N · La Mesa, CAN2833AMamuzich Robert J DBA · Deming, NMN2833CKizer Charlene A · Albany, ORN2833DScott Glen H · Spring, TXN2833FWeaver Arnold G · Sandusky, MIN2833NLansing Community College · Mason, MIN2833RRegistered aircraftN2833YLancaster Mark E · Buffalo, SCN2833ZVaughn James F · La Porte, INN28345Avivus LLC · Austin, TXN28347Adriatic Holdings LLC · Cheyenne, WYN2834ADalton John B · Dallas, ORN2834BSager Arthur · Joseph, ORN2834COsborne David A · San Antonio, TX
Back to AD 2007-04-19 R1