Skip to content

Registered aircraft · 6,349

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

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:80-25-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2') ORDER BY n_number

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:80-25-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
  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:80-25-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
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.

N67995New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N 15282128 N67GPGood Impressions Aviation LLC · Bedford, TXBuilt 2005 · S/N 6-4912 N67JSC&L Aviation Ltd · Maysville, KYS/N JS1 N6800KHoech Terry H · Bothell, WABuilt 1949 · S/N 16-628 N6801DMorstad Jerry D · Albert Lea, MNBuilt 1958 · S/N JW1 N6806KBourdon David · Green Cove Springs, FLBuilt 1949 · S/N 16-639 N6807KLemire Darryl M · White Bear Lake, MNBuilt 1949 · S/N 16-636 N6811KBashore Charles A · Madison, ALBuilt 1949 · S/N 16-646 N68137Wind Walker LLC · Tucson, AZS/N 15285316 N68141Erb William F · Oakdale, CABuilt 1978 · S/N 15282144 N68165Dahmer Frank J · Micanopy, FLBuilt 1978 · S/N 15282157 N68167Toms Annette M · Liberty, NCBuilt 1978 · S/N 15282159 N68184Wichita Area Technical School · Wichita, KSBuilt 1978 · S/N 15282170 N6818KEckberg Robert K · Dakota City, IABuilt 1949 · S/N 16-650 N68195Richmor Aviation Inc · Scotia, NYBuilt 1978 · S/N 15282177 N68198Jw Plane Leasing LLC · Wausau, WIBuilt 1978 · S/N 15282179 N68206Fs Investments LLC · White Lake, MIBuilt 1978 · S/N 15282184 N68211American Aviation Inc · Brooksville, FLS/N 15282188 N68212Dynasty Adventure Inc · Mentone, CABuilt 1978 · S/N 15282189 N68220Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282194 N68225Brown Steven E · Paynesville, MNBuilt 1978 · S/N 15282198 N68228Van Thomme Wayne A · Faribault, MNBuilt 1981 · S/N 15285320 N6822KGoad Graham · Mcminnville, ORBuilt 1949 · S/N 16-653 N68234Bryant William E · Fort Bragg, NCBuilt 1978 · S/N 15282203 N68237Registration Pending · Tacoma, WARegistration pendingBuilt 1978 · S/N 15282204 N68242Wilson Timothy J · Arlington, AZBuilt 1978 · S/N 15282205 N68246M2g Aviation LLC · China Grove, NCBuilt 1978 · S/N 15282208 N68257Bates Steven B · Phelan, CAS/N 15282213 N68260Flycarolina LLC · Rock Hill, SCBuilt 1978 · S/N 15282214 N682666s Aviation Corp · Orlando, FLBuilt 1978 · S/N 15282218 N68280Frint Michael R · Elk Grove, CABuilt 1978 · S/N 15282226 N68287Lockwood Albert G · Eden, IDS/N 5-1475 N682DCSteele Aviation Inc · Walnut Cove, NCBuilt 1961 · S/N 22-8660 N68302Fulltron Aviation LLC · Springfield, MOS/N 15282240 N6831KAbbott Cedric M · Buckfield, MEBuilt 1949 · S/N 16-667 N68323Briggs Jeffery M Trustee · Royal Oak, MIBuilt 1978 · S/N 15282257 N68329Ace Aircraft Leasing Inc · Nazareth, PAS/N 15282261 N68332Wings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285326 N68334University Of Michigan Flyers · Ann Arbor, MIBuilt 1978 · S/N 15282265 N68342M & S Air Supply Inc DBA · Hawthorne, CABuilt 1978 · S/N 15282269 N68344South Bay International Flight Association Inc · Torrance, CABuilt 1978 · S/N 15282271 N68348Tully Robert · Eighty Four, PABuilt 1978 · S/N 15282275 N68349East Derrick A · Cullman, ALBuilt 1978 · S/N 15282276 N6834KKilbourned Garrot · Liberal, KSS/N 16-669 N68356Don Davis Aviation Inc · Henderson, KYBuilt 1981 · S/N 15285327 N6835KWill Robert I Jr · Shoreline, WAS/N 16-670 N6836KBundrant Wlliam D · Snellville, GABuilt 1949 · S/N 16-671 N68402Space Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 15282284 N6840KValley Airways Inc · Scottsbluff, NEBuilt 1949 · S/N 16-675 N68414Wright Duane C · Sanford, FLBuilt 1978 · S/N 15282288

Back to AD 80-25-02 R2