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.
N3814VCert Works LLC · Bennett, CON3814WN3814w LLC · Maumee, OHN3814YLadner Donald E · Centerville, TXN3815DAlaska Homested Lodge Inc · Soldotna, AKN3815EHonest Dog Farms LLC · Fayetteville, GAN3815FOrr Charles W III · San Ramon, CAN3815KShoemaker James W · Hilltop Lakes, TXN3815PNorth Louisiana Aviation LLC · Mer Rouge, LAN3815WCk Aviation LLC · Milledgeville, GAN3815YBorean Anthony J · Olathe, CON38166S&P Airplane Sales · Branson West, MON38168Jjj&S Aviation Corp · Brooklyn, NYN3816FHotzel Jeffrey F · Gladstone, MON3816PJohnson Dale M · Seminole, TXN3816QGoli Aviation LLC · Raleigh, NCN3816SKey Field Flyers LLC · Toomsuba, MSN3816T1 Vision General Aviation LLC · Sioux City, IAN3816YDegregorio Dennis P · Tinley Park, ILN3816ZBouchard Timothy D · Valdez, AKN38175Fhg Springbrook Corp · Wilmington, DEN38177Archer Enterprises Corp · Ossining, NYN38178Gcs Aero LLC · Laramie, WYN3817DOff The Step Inc · Creswell, ORN3817MGulf Skies LLC · Kalispell, MTN3817PCoslor Donald D Jr · Grand Island, NEN3817QMoses Aviation Services LLC · Uvalde, TXN3817XPeterson Randall J · Lake Havasu City, AZN3817ZLivermont Joann M · Dillingham, AKN38180Raymond Katherine · Akron, OHN3818QRanch Hand Flying Club Inc · Gardiner, NYN3818TMccawley Gerald J · Parksley, VAN3818WHeadwinds Maintenance Inc · Fort Pierce, FLN3818XAcme Racing LLC · Overland Park, KSN38190Classic Aviation Inc · Pella, IAN38191Burgess Sheldon A · Raymond, MSN38193Ramirez Katherin · Homestead, FLN38195Inspiration Aviation Ministries · Waterville, MEN38197Anderson Loran · Cooperstown, NDN38198Zero Mike LLC · Chattanooga, TNN3819FBuntings Grassroots Aviation LLC · Selbyville, DEFirst renewal noticeN3819PLucas Lester L · Napa, CAN3819QGulf Coast Aero Club Inc · Sarasota, FLN3819TChism Alicia L · Lawrence, KSN3819XBoerne Flight Options LLC · Boerne, TXN3819YLaycock Justin D · Johnson City, TNN381ACKarter Transport Enterprise LLC · Monterey, CAN381BTPiper Aircraft Inc · Vero Beach, FLN381CAOltman Neil R · Sandia Park, NMN381CC182 Flight Corp · Bronx, NYN381CDN381cd Aviation LLC · Ventura, CA
Back to AD 2007-04-19 R1