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.
N5368JJones Anesthesia LLC · Arcadia, INN5368PHeck Paul A · Santa Rosa, CAN5368TAviation Here LLC · Lino Lakes, MNN5368UBornwasser Louis W · Prospect, KYN5368WFuller Jonathan T · San Antonio, TXFirst renewal noticeN5369AMartens Charles H · Nokomis, FLN5369DBrown Hector M · Glenwood Springs, CON5369EKing Curtis M · Tenino, WAN5369NDecio Justin M · Portsmouth, NHN5369RArmbruster LLC · Amherst, OHN5369YPollard William Edward · Big Spring, TXN536AMTriniair LLC · Warner Robins, GAN536BBBas Air LLC · Valparaiso, INN536CMCherry Hill Aviation Inc · Freetown, INN536EREmbry Riddle Aeronautical University Inc · Prescott, AZN536EUSarabay Aviation Partners LLC · Sarasota, FLN536GRNational Aircraft Leasing Corp · Greenville, DEN536GSLvhbj LLC · Portola Valley, CAN536GTNorthern Planes Aerosport LLC · Algona, IAN536JRSale Reported · Port Orange, FLSale reportedN536JSShoffner James P Jr · Denver, CON536KEngage Helicopters LLC · Sarasota, FLN536KSKent State University · Stow, OHN536LAhmed Ejaz DBA · Carrollton, GAN536MAWilliams Fertilizer Services LLC · Oregon, MON536MMTroyer David · Newnan, GAN536NDPhoenix East Aviation LLC · Daytona Beach, FLN536PSky High II LLC · Clinton, NCN536PUMetro Aircraft Co · Bloomington, MNN536SN5405a LLC · Beverly Hills, CAN536SHCentral Ky Ag Air LLC · Harrodsburg, KYN536TCI C Aviation LLC · Scottsdale, AZN536THLanier Equipment Leasing LLC · Gainesville, GAN536TPDownhill Aero LLC · Kalispell, MTN536WWright Jack · Fortson, GAN536WCN8qb LLC · Thief River Falls, MNN536WGAdvantage Aviation Inc · Palo Alto, CAN536XDel Rio Aviation Inc · Paso Robles, CAN53703University Of Michigan Flyers Inc · Ann Arbor, MIN5370DWhitten Wayne M Sr · North Berwick, MEN5370ESwanson Philip A · Star, IDN5370FRegistered aircraftN5370LSouthern Colorado Flight Professionals LLC · Pueblo, CON5370PBlythe Anne T · Paso Robles, CAN5370TK.M. Biggs Inc · Lumberton, NCN5370UPogany Steve C · Anchorage, AKN5370WAllen Lanny Dean · Indianapolis, INN53713Haley Wendell B · Williamson, GAN53718Seals James E · Oxford, ALN53719Allen Scott P · Wellington, NV
Back to AD 2007-04-19 R1