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.
N56864Odom Joseph L Jr · Lake Mary, FLN5686PGray Gary L · Frederick, OKN5686QBolton Nicolas · Murfreesboro, TNN5686UHobbs Stanley T · Middleburg, FLN5686WPromedical Inc · Pfafftown, NCN56874Styer David B · Pendleton, ORN5687BOsojnak Keith J · Cottonwood, UTN5687QRegistered aircraftN5687SRobbins Warren N · Chandler, AZN5687YBrouse Dan T · Magnolia, TXN56887Leavitt Teyvin M · Coeur D Alene, IDN56888Ameer & Zaki Aircraft Solutions LLC · Lewes, DEN56889Red Choochoo LLC · Madison, INN5688BJordan Bros · Centre, ALN5688C5688c LLC · Glendale, AZN5688JAnderson Aerial Spraying Service Inc · Canby, MNN5688KRouw Bruce L · Leesburg, FLN5688STanneberg Larry · Coulee City, WAN5688TJoe Koch Construction Inc · Youngstown, OHN5688WSerendipity Rentals LLC · Denver, CON56890Fink David J · Georgetown, TXN56898Evans Katrina · Watkinsville, GAN56899Mcdonald George · Inverness, FLN5689DKelly G L · Blacksburg, VAN5689NRobinson Ryan A · Burbank, CAN5689PMarsala Joseph · Uxbridge, MAN5689QReynolds Shawn E · Ventura, CAN5689UGeorge Marc J · Harker Heights, TXN5689VStardust Aviation LLC · Farmingdale, NYN568BCN28179 Inc · West Gilgo Beach, NYN568CPCivil Air Patrol · Maxwell Afb, ALN568DDavid Glen E · Ash Fork, AZN568EParagon Flight Training Co · Fort Myers, FLN568FLAir Ventures Flying School LLC · Smithfield, RIN568GMSommersdorf Thomas G · Orlando, FLN568HBKurreck Tim R · Caldwell, IDN568JKBell Frank D · Tuxedo, NCN568KAtp Aircraft 3 LLC · Wilmington, DEN568LTLuckie Mark O · Ashland, KSN568MTMiddle Tennessee State University · Murfreesboro, TNN568NDAerosim Academy Inc · Sanford, FLN568PBas Part Sales LLC · Greeley, CON568QAWhite Fence Aero LLC · Denver, CON568RVNeumayer Barry A · Redlands, CAN568SRHaney Jeffrey · Carrollton, GAN568TRedfearn Todd D · Uvalde, TXN568TWWestray James H · Gainesville, GAN568WCormell Eric M · Caldwell, IDN568WACarver Clarence K Trustee · Lutz, FLN568WFCruz Norman D · Las Vegas, NV
Back to AD 2007-04-19 R1