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.
N4818DBald Eagle Flying Club · South Portland, MEN4818LFischer Denise L · Lake View Terrace, CAN4819GVeer Aviation Tx LLC · Houston, TXN4819JDoran Jeffrey T · Westerville, OHN4819NSilva Robert · Davis, CAN4819QPuryear Rodney K · Pampa, TXN4819TJacob Rolando V · Las Vegas, NVN481AArcher Aircraft LLC · Wilmington, DEN481ACVogel Lawrence O · Gig Harbor, WAN481CPBlue Water Aviation LLC · Oakman, ALN481DGrey Goose LLC · Wasilla, AKN481DMEdgewood Capital LLC · Joplin, MON481EMClark Jeffrey V · Libertyville, ILN481EREmbry-Riddle Aeronautical University · Daytona Beach, FLN481GSSchmidt Grant S · Jamestown, NDN481HWilliams Stephen C · Georgetown, MEN481JCollins Jason · Mansfield, OHN481JLWolfco Timber Services LLC · Lebanon, ORN481MASlavens Timothy W · Howard City, MIN481PMoody Bible Institute Of Chicago · Spokane Valley, WAN481SAerogracia LLC · Heritage Ranch, CAN481TN481t LLC · Pensacola, FLN481TRBowen Tim S · Robstown, TXN481WSBoer John W · Okeechobee, FLN481XCMarino Jerry C II · San Francisco, CAN48205Popinko Charles D · Obrien, FLN4820DBledsoe Duane C · Glendale, AZN4820EHogan Mark C · Sisters, ORN4820FS&S Aviation Plus LLC · Greenville, ILN4820GAckerman Garry · Plano, TXN4820LFick Paul R · Deansboro, NYN4820SCalico Construction Inc · Kensington, MDN4821AMeyer James D · Cheney, KSN4821FOestreich Klaus M · Needville, TXN4821LFlying Rocks LLC · Sparkill, NYN4821S4821s LLC · Ponte Vedra Beach, FLN4821USouth Side Corp · Loomis, NEN4822ALybarger Michael L · Hot Springs, ARN4822DRegistered aircraftN4822GHighpoint Strategies LLC · Cypress, TXN4822LMonaco Francis Achille · Martinez, GAN4822NBalinski Stephen W · Lusby, MDN4822SHolladay Pamela J · Louisville, KYN4822VCantrell David R · Albany, GAN4823FEden'S Marine LLC · Jensen Beach, FLN4823JHaunstein Manfred · Weirsdale, FLN4823PWilliams Charles S · Pearland, TXN4823TCrane Kenneth J · Clinton, INN4823VStratus Air LLC · New Orleans, LAFirst renewal noticeN4824FWheeler Michael P · Declo, ID
Back to AD 2007-04-19 R1