Skip to content

Registered aircraft · 68,369

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:90-04-06-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:90-04-06-R1') 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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N246RKFreeborn Mark Trustee · Phoenix, ORS/N 22861 N246RLSwiss Eagles Inc · Las Vegas, NVBuilt 1984 · S/N L-0026 N246SBBeatty Steve K · Glendale, AZBuilt 2004 · S/N 0130 N246SGLensis Thomas M · Wilmington, NCBuilt 2003 · S/N 473-2003 N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023 N246TMTango Mike Aviation LLC · Seneca Falls, NYS/N 3238 N246TTTerry Timothy D · Gainesville, TXS/N 70518 N246UAdelaar Holdings LLC · Missoula, MTBuilt 2020 · S/N 3360 N246VABrascher Harry M · Spotsylvania, VABuilt 2003 · S/N 81121 N246WF2 4 6 Whiskey Foxtrot LLC · Knoxville, TNBuilt 1973 · S/N M-1427 N247Bonewitz John A · Grapevine, TXBuilt 1999 · S/N 23846 N24704Blumer Charles · Fullerton, CAS/N 38-78A0785 N24708Spartan Education LLC · Tulsa, OKBuilt 1977 · S/N 15280332 N2470HKing Bruce J · Waldport, ORBuilt 1979 · S/N 18-7909192 N2470MFluckey Gary T · Homer, AKS/N 12-1551 N24714Bourne Randy D · Orting, WABuilt 1977 · S/N 15280334 N24718Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0002 N2471ARink Raymond E · Mimbres, NMBuilt 1952 · S/N 22-809 N2471LGuzman Gerald F · Winchester, CABuilt 1979 · S/N 38-79A0712 N2471NTwo Dot Aircraft LLC · Kalispell, MTBuilt 1979 · S/N 38-79A0859 N2471USchroeder Nyla R · Minneapolis, MNBuilt 1979 · S/N 28-8090049 N24725Technical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 15280341 N2472JDolev Eyal · Portland, ORBuilt 1977 · S/N 15279969 N2472MAufderhar Kenneth G · Lopez Island, WABuilt 1947 · S/N 12-1692 N2472NVann Dudley C DBA · Greenville, NCBuilt 1979 · S/N 38-79A0860 N2472VColthirst Michael · Clarksville, TNBuilt 1982 · S/N 38-82A0064 N2473MMcgahan Jackie L · Kenai, AKBuilt 1947 · S/N 12-1690 N2473NKline Glenn A · Iron River, MIBuilt 1979 · S/N 38-79A0861 N2473PAnderson Tony V · Pendleton, ORBuilt 1955 · S/N 22-2848 N2473WCahill Chad · Edmond, OKBuilt 1985 · S/N 28-8590073 N2473YFunderburg Erskine R · Pell City, ALBuilt 1985 · S/N 28-8590074 N2474BLetourneau University · Longview, TXBuilt 1978 · S/N 38-79A0078 N2474FCoke Roger T · Clarksville, INFirst renewal noticeBuilt 1979 · S/N 38-79A0468 N2474GSchwartz Theodore Francis · Fogelsville, PABuilt 1979 · S/N 38-79A0541 N2474MAshe David J · Randle, WAS/N 12-1553 N2474PSeidel William G Jr · Poway, CABuilt 1955 · S/N 22-2849 N2474ZTeufel Jeffrey · North Pole, AKBuilt 1954 · S/N 18-3592 N24752Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280355 N2475ABowser Dwight H · Anchorage, AKBuilt 1952 · S/N 22-818 N2475LDeralex Airways LLC · Miami, FLBuilt 2001 · S/N 17280990 N2475MN B Tweet And Sons · Nome, AKBuilt 1947 · S/N 12-1688 N2475PErickson Scott L · Omaha, NES/N 22-2796 N2475TDurban George E · Indianola, IABuilt 1978 · S/N 38-78A0812 N24763Big South Fork Aerospace LLC · Pine Knot, KYBuilt 1977 · S/N 15280361 N24764Riya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280362 N24765Alpha Aircraft International LLC · Lake Worth, FLS/N 15280363 N24766Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280364 N24767Tennessee Technology Center At Morristown · Morristown, TNBuilt 1977 · S/N 15280365 N2476ESkyspot Advertising LLC · Lakeland, FLBuilt 2001 · S/N 172S8784 N2476GSouthern Region Machine Service Inc · Castlewood, VABuilt 1979 · S/N 38-79A0542

Back to AD 90-04-06 R1