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.
N4275JEden Aviation LLC · Benbrook, TXN42763Vf 126 Aviation LLC · Chicago, ILN427653 B Farms Inc · Pinetown, NCN42766Jessee Robert A · Winter Haven, FLN42768Horn Terry D · Sharpsburg, GAN4276JDever Jake P · Destin, FLN4276PNiec Steven M · Clio, MIN4276QOjdrovich George · Steamboat Springs, CON4276REchols Mark R · Diana, TXN4276TTippett James R · Brownsville, TNN42770Barthelette Kenneth E · Pawleys Island, SCN42777Cantwell Patrick W · San Francisco, CAN4277QRawlins William David Sr · Martinez, GAN4277ZHart Lewis W · Rexburg, IDN42787Macair Aviation LLC · Xenia, OHN4278MOwen Mark · Clyde, TXN4278ZDevoe Ryder Keegan · Encinitas, CAN42792Baxter Adam W D · Anchorage, AKN4279HDeal Glen K · Palmer, AKN4279JUS Flight Academy International Inc DBA · Post, TXN4279KHawkins Terry D · Conyers, GAN4279SSteinbacher Deane E · Waterford, WIN4279TLambert Arthur A · Pinckneyville, ILN4279ZSwiss John T · Anchorage, AKN427ACNoyes Shawn R · Hudson Oaks, TXN427ASOliver Leland E · Tucson, AZN427ATMockingbird LLC · Bloomington, INN427BDNostra Aeris LLC · Gassville, ARN427BYRobinson Tracy R · Veneta, ORN427CAChippewa Aerospace Inc · Gainesville, FLN427CPCivil Air Patrol Inc · Maxwell Afb, ALN427CRAb Prop Plane II LLC · Metairie, LAN427CSVan Bortel Aircraft Inc · Arlington, TXN427CWRural Orthopedic Care LLC · Ardmore, OKN427DKNelson Michael E · Gig Harbor, WAN427DPCharlie Alpha Inc · Calabasas, CAN427DTEagle Eye Helicopter LLC · Fort Pierce, FLN427DWFlyin Phar LLC · Salt Lake City, UTN427EFIshii Thomas W · Roseville, CAN427EMBundy Edward · Eagle, IDN427EPChristiansen Aviation LLC · Wilmington, DEN427G5 Star Farm Management Inc · Linden, CAN427GBBoies Guy J · Mason, TXN427GKToal Timothy R · Milan, ILN427HHSinopoli Albert L · Friendswood, TXFirst renewal noticeN427JCKad Enterprises LLC · Everett, WAN427JDMule Air LLC · San Antonio, TXN427JGLigon Scott A · Florence, ALN427JLLester James A · Brooksville, FLN427KSchiavone John Anthony · Potomac, MD
Back to AD 2007-04-19 R1