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.
N3195ZMcgrady Chadwick Paxton · Glade Park, CON31969Chandelle Flying Club Inc. · Austin, TXN3196AKloker Daniel E · Owasso, OKN3196CWeir Ryan L · Buckley, WAN3196RS & S Aviation Co · Ball Ground, GAN3196SHistoricair Transport LLC · Midlothian, TXN3196TNicholson Perry R · Merlin, ORN3196WTs Aviation LLC · Sioux Falls, SDN3196YRickles Richard J · Chamblee, GAN31977Wedekemper Donald E · Howell, MIN3197CScott James D · Mesa, AZN3197FWhite River Land And Timber Co LLC · Greenbrier, ARN3197MBonanza Five Flying Club Inc · Roswell, GAN3197SJarvis Jason O · Cresson, TXN3197TMundle Jeffrey A · Ashland, ORN3197YMonahan Robert J · Bulverde, TXN3197ZSlayden Steven M · Rhome, TXN31985Ledge Aero Inc · Holt, MIN31988Little Dog Aviation LLC · Branchburg, NJN3198FDepinet Rodney J · Glen Saint Mary, FLN3198LKatsahnias George T · Denton, TXN3198WRobert And Donna Odegaard Family Lllp II · Kindred, NDN3198YKembel Cary A · Snyder, CON31995One Zero Tango LLC · Chattanooga, TNN31996Seacoast Plane Partners LLC · Exeter, NHN3199CGreenleaf Michael G · Tacoma, WAFirst renewal noticeN3199DHebda Thomas W · Colorado Springs, CON3199GDriftless Aviation LLC · Wilmington, DEN3199HHills Holding · Newark, DEN3199JSietsma Lawrence F · Indialantic, FLN3199RUmina Michael P · Hopkinton, MAN3199TMortgage Experts LLC · Homestead, FLN3199UNiner Niner Uniform LLC · Elk Mound, WIN3199WCoastal Sky Partners LLC · Wilmington, DEN3199YClearwater Valley Aero Club Inc · Kamiah, IDN319AMJones Arthur L · Bend, ORN319AUChristiansen Aviation LLC · Wilmington, DEN319AZRegistered aircraftN319CAAcree James · Euless, TXN319CBBoyer Richard · Georgetown, TXN319CCYale Companies LLC DBA · Indianapolis, INN319DCBecker Dennis P · Kelso, WAN319ECRansom Robert W · Moorestown, NJN319EGVertx Fleet Holdings LLC · San Diego, CAN319EPEpic Aviation Inc · New Smyrna, FLN319FTPerez Guillermo T · Castaic, CAN319GSilver Star Holdings LLC · Aurora, CON319GHHalverson Gregory W · Portland, ORN319GKKonrad Gary T · Howell, MIN319GRGuinn John F · Baxter, TN
Back to AD 2007-04-19 R1