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.
N4363LVeritas Holdings LLC · Washington, DCN4363MArk 84 LLC · Wilmington, DEN4363RSky Walker Flight School LLC · Adrian, MIN4363TAmmons Jeffrey S · Cypress, TXN4363ZOcean Aerial Ads Inc · Berlin, MDN43647Zg Aviation LLC · Alexandria, MNN43648Bels Holdings LLC · Albert Lea, MNN4364APapp Frank J · Fort Mohave, AZN4364BFairway Aviation LLC · Great Bend, KSN4364FPwc Hawaii Corp · Lahaina, HIN4364JDuffin Glenn R · Woodland Hills, UTN4364PMeehan Patrick K · Anchorage, AKN4364QStotts Boys Aviation LLC · Corcoran, MNN4364TComputec Technical Solutions Inc · Eighty Four, PAN4364WGlickman Joel H · Gansevoort, NYN4365Wells Canda R · Holdrege, NEN43650Hughes Richard B · Annapolis, MDN43652Tarcelo Maria Jocelyn F · Sun City, CAN43654Aeroventures Flying Club Inc · Lawrenceville, GAN43655N43655 LLC · Newark, DEN4365DGriffin Donald A · Alma, ILN4365FBumgardner Jerry C · La Crosse, WIN4365JHofer Jeffrey · Lugoff, SCN4365QJackson Rickey L · Edmond, OKN4365RCsa Aircraft Leasing LLC · Salt Lake City, UTN4365VPfander Scott J · Litchfield Park, AZN43661Gordon James R · Greenwood, INN43664Johnston William R · Jackson, NCN4366JRegistration Pending · Daytona Beach, FLRegistration pendingN4366KStier Dominic F · Grand Meadow, MNN4366NFrisbie Kevin R · Louisville, KYN4366RHyland Mark R · Poland, MEN4366WPrentice Chris · Independence, ORN4366ZEse Aviation LLC · Houston, TXN43671Rush Micah N · Salem, ORN4367DCw Aviation LLC · Jefferson City, MON4367GDimenno Phillip A · Windermere, FLN43685Horizon Aviation LLC · Brooks, GAN43688Blue Skies Aircraft LLC · Kalispell, MTN4368HMuskogee Airmen Inc · Muskogee, OKFirst renewal noticeN4368TWillgress Edwin R Jr · Mundelein, ILN4368UBorges Jr Frank · Angwin, CAN4368VWaunch Robert L Trustee · Eastsound, WAN43690Fly Twin Commanche LLC · Peoria, AZN43693Milazzo Robert J · Sudbury, VTN43695Kinney Ian · Calhoun, LAN4369AWinston William A · Bremo Bluff, VAN4369NJ J Bagley Transportation Co LLC · Chalfont, PAN436ACKimmel Aviation Insurance Agency Inc · Greenwood, MSN436AGSkywest Leasing Inc · St George, UT
Back to AD 2007-04-19 R1