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.
N5361NKdb LLC · Underwood, IAN5361WRoberts Misty L · Fountain Hills, AZN53622Mc Air LLC · Miami Beach, FLN5362AFerguson Lynn D · Alpine, WYN5362FPetros Michael · Chandler, AZN5362HMccue Tedd R · Eveleth, MNN5362LTiedemann Douglas A · Skaneateles, NYN5362UHebert Loree W Jr · Saint Francisville, LAN5362XSky West Aviation Inc Trustee · Albuquerque, NMN53630Arlington Flight Services Inc · Arlington, WAN53632Siple Aviation LLC · Kalispell, MTN5363JPulliam Joe Clinton Jr Trustee · Pilot Point, TXN5363KMission Aviation Training Academy · Arlington, WAN5363LTeehee Max L · Searcy, ARN5363SOwens Scotty · Crofton, KYN5363YThompson Frank L · Weiser, IDN5363ZClover Park Technical College · Lakewood, WAN53646Fhas LLC · Cassopolis, MIN5364ABradley Flying Association · Peoria, ILFirst renewal noticeN5364BWest James L · Roswell, NMN5364EGaddis Jason · North Las Vegas, NVN5364KAir S&T LLC · San Juan Capo, CAFirst renewal noticeN5364WCowell Clayton R · Garvin, OKN53650Phillips Michael A · Bozeman, MTN53651Christiansen Aviation LLC · Wilmington, DEN5365EOsborne Steven V · Douglas, WYN5365PLarsen Roy E · Placerville, CAN5365QWelborn Mark · Boonville, NCN5365SGamm Stephene Wade · Warrenton, VAN5365WPugh Harrison B · Tallahassee, FLN5365XSale Reported · Greeley, COSale reportedN53663Iron Shield Aviation LLC · Fort Pierce, FLN5366ABlack Iron Wood LLC · Sarasota, FLN5366DHeinrich Rivero Hinze Max · San Antonio, TXN5366FGoodrich James · Jacksonville, MON5366JSlipstream Aviation LLC · Calera, ALN5366KAmerican Patrols Inc · Midland, TXN5366LDurnal William H · Washington, NCN5366PGreenlaw Russell C · Livermore, CAN5366WM & S Aviation LLC · Lebanon, MON5367DBandrowicz Leon A · Shelby, MIN5367EHentges Anthony · Canby, MNN5367FBlackburn Kenneth P Trustee · Dubuque, IAN5367HWingsleasing LLC · Wichita, KSN5367LMiller Grady F · Kingsland, TXN5367PBerg Robert M · Culver, ORN5368AValiair Limited Co Trustee · Casper, WYN5368BGachis Gary Allen · Vacaville, CAN5368EHarris Adventures LLC · El Prado, NMN5368HPacific Flight Aviation LLC · Costa Mesa, CA
Back to AD 2007-04-19 R1