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.
N7309SRegistration Pending · Tahoe City, CARegistration pendingN7309TRognlie Brent R · Westminster, CON730AKMcmullen Michael J · Columbia, SCN730BLast Approach LLC · Fort Myers, FLN730EREmbry-Riddle Aeronautical Univeristy Inc · Prescott, AZN730HAHonaker Group LLC · Sellersburg, INN730LBEarly Bird Aviation LLC · Rillito, AZN730LCJones Christopher N · Edgewood, WAN730LUTextron Aviation Inc · Wichita, KSN730WMDennings Greg B · New Bremen, OHN73100Alaska Air Taxi LLC · Anchorage, AKN73103Bfl Aviation LLC · Bakersfield, CAN73105Jlk Management LLC · Kerrville, TXN7310GMccall Freddie W Jr · East Brewton, ALN7310QDye Development LLC · Salem, OHN7310TYowell Albert W · Etlan, VAN73113Top Flight Aviation Inc · Corona, CAN73116Taildraggers Flyers Inc · Saint Joseph, MIN73118Hudson Donald L Jr · Sellersburg, INN7311VWiliams Daniel L · Liverpool, NYN73123Lake Clark Air Inc · Port Alsworth, AKN7312AJohnson Thomas F · Buckeye, AZN7312GKlitzke Lucanus E · La Plata, NMN7312NOber John · Candor, NYN7312QRegistration Pending · Wilmington, DERegistration pendingN7312SCuneo Timothy Angelo · Twin Falls, IDN7312THangar 20 Flying Club LLC · Climax, MIN73131Fremont Flight Academy LLC · Fremont, OHN73134Harborside Aviation Services Inc · Punta Gorda, FLN7313APerkins David A · Locust Grove, OKN7313GBend-Over Hill Aviation LLC · Dover, DEN7313QWoodall Dan · Raleigh, NCFirst renewal noticeN7313SRogers Matthew H · South Berwick, MEN73146Oregon State Flying Club Inc · Corvallis, ORN73148Kinney Transportation · Columbia, MON73149Good Flight Aviation LLC · Stockton, CAN7314ASchultz David · Middleton, IDN7314GKittle Aviation LLC · Wichita, KSN7314MFrickel Daniel R · Atkinson, NEN7314TCarney Mark A · Emporia, KSN73151Hawaii Aviators LLC · Ewa Beach, HIN73154Bishop Services LLC · Ellisville, MSN7315ATiny Sparrow Aviation LLC · Irvine, CAN7315KLittle James R Jr · Jackson, WYN7315MRolling Cole LLC · Kalispell, MTN7315QNotman Steven J · Maunaloa, HIN7316ALangley Russell M · Adair, OKN7316GCox Capital LLC · Rushville, MON7316MSteven Bryant · Boise, IDN7316NHayes Charles David · North Pole, AK
Back to AD 79-10-14 R1