AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N828TATravelaire Service Inc · Wilmington, DEN828WWMaranatha Insurance Services Inc · Rancho Cucamonga, CAN828YLong Island Aviators LLC · Seaford, NYN8290BSchooman Clarence G · Marion, TXN8290LPretty Plane LLC · Nixa, MON8290SNewsome Jeff · Blackwell, OKN8291AScott William M · Spring Hill, FLN8291ERangers Flying Club Inc · Eden Prairie, MNN8291GBullock Brooks M II · Cartersville, GAN8291LUsglap LLC · Fort Morgan, CON8291MElbs Aviation LLC · Pell City, ALN8291SSipes Jacob L · Sunbury, OHN8291TKnight James M · Wilton, CAN8291UBarnett William M · Rolla, MON8291XChandler Christopher G · Cooperstown, NYN8292Gulf Coast Helicopters Inc · Pearland, TXN8292ADeforest Dennis L · Hamilton, INN8292BEagle Eye Aerial Imaging LLC · Chagrin Falls, OHN8292EP&N Corp · Marion, IAN8292LBrown Troy M · Austin, TXN8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKN8292QFitzgerald John A Jr · Ester, AKN8292SStephens Ralph W · Reno, NVN8292URettkowski Brady A · Hermiston, ORN8292XHeadings Daniel E · Salem, ORN8292ZBenedick Yachal O · Wilsey, KSN8293AMcgreevy Stephen P · Poplar Grove, ILN8293EFiorini Anthony Wayne · Tuttle, OKN8293QBaker Marianne J · Raeford, NCN8293TNational Refining Co · Owosso, MIN8293ZAv8r Aviation LLC · Yakima, WAN8294FWalters Craig S · Lake City, FLN8294SLogtime Flight LLC · Lancaster, TXN8294XFranco Stephen B · Chicago, ILN8295AHairston Marvin A · Peck, IDN8295BSkywriters Inc · Ferndale, WAN8295EFrump Leasing Inc · Newburgh Heights, OHN8295UCrawfish Co LLC · Starkville, MSN8296EMosbach Rene A · Sandia, TXN8296GKiehl Austin J · Winnett, MTN8297BSchler Joseph B · Reno, NVN8297EConaway Scott J · Traverse City, MIN8297SBergmann Joshua A · Menomonie, WIN8297UMcburney Richard O · Hudson, NCN8297ZMartinez Gabriel M · Santa Fe, NMN8298EAberdeen Flying Service · Aberdeen, SDN8298FAustin Leslie M · Greenville, INN8298UCollins Roberto · Naples, FLN8299AStevenson James W · Oregon, WIN8299BJohnston Keith G · Honolulu, HI
Back to AD 79-10-14 R1