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.
N3187UMillikan Kimball S · Honolulu, HIN3187WG S Aviation Inc · Stilwell, KSN3187YMiller Richard G · Anson, TXN3187ZRucks Chad W · Okeechobee, FLN31885It Is Well · Kennett, MON3188NMhr44 LLC · Queen Creek, AZN3188QLutz Paul A Trustee · Seville, OHN3188SCrossman Charles · Rusk, TXN3188TRucinski Edward A · Climax, NCN3188UAsb Avionics LLC · Mojave, CAN3188YIngram Patrick Joseph · Pinedale, WYN3189CSmith David J · Duluth, MNN3189MSnowbird Aviation Corp · Signal Mountain, TNN3189QBoll Weevil Flyers LLC · Reedville, VAN3189SMarvin Franz Interests Inc · Victoria, TXN3189ULaney Donald R · Inkster, MIN3189YSkotynsky Michael · Broomfield, CON3189ZSilverhawk Aviation Academy LLC · Caldwell, IDN318ALeaders Robert O · Clear Lake, MNN318ACAughenbaugh Alan M · Iroquois, SDN318AWWeinberg Andrew B · Meadow Vista, CAN318CAKornegay Patrick · Harlingen, TXN318CCVan Schoonhoven Nicholas R · Kent, WAN318DSchutes John T · Brimfield, MAN318DMDelta Kilo Mike LLC · Rayville, LAN318DSStrodtbeck Dale G · Eureka, MTN318EBEdwards Robert G · Madison, WIN318FCMendoza Jeremy · Honolulu, HIN318GAero Fliers Inc · Akron, OHN318JMN318jm LLC · Wilmington, DEN318JRFlywell Aviation LLC · Bowling Green, KYN318LLLee Aviation Services LLC · Wilson, NCN318MAHigh Plains Aviation LLC · Nara Visa, NMN318MBHenderson Michael E · Edmonds, WAN318ME1st Avenue Ttc LLC · Los Angeles, CAN318MFBusy Bee Helicopters LLC · Lone Jack, MON318NRNorthern Arizona Investment Group LLC · Prescott, AZN318PABird Acquisition LLC · Phoenix, AZN318PWN318pw LLC · New Canaan, CTN318RALouden Bruce H · Kalispell, MTFirst renewal noticeN318RCLafrance Lon H · Rocky Mount, MON318RNPendas Aviation Corp · Orlando, FLN318SJObr Leasing · Manassas, VAFirst renewal noticeN318TCGilmer Thomas · Toccoa, GAN318TMOgino Todd T · Barrington, ILN318UTraffic Law LLC · Tampa, FLN318VFShramek Troy A · Bossier City, LAN318WCDelta Dusters LLC · Lake Providence, LAN318WMQuinn James Yancie · Farmers Branch, TXN318WTThompson Brent D · Bloomington, IN
Back to AD 2007-04-19 R1