Skip to content

Registered aircraft · 68,367

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.

N1242WDeland Air And Sea Brokerage Inc · Deland, FLBuilt 2012 · S/N 0001 WKBA N1242XCarpenter Charles P · Tarzana, CAS/N 115 N12439Vann Dudley C DBA · Greenville, NCBuilt 1973 · S/N 17261982 N1243ASquadron One LLC · Vienna, VABuilt 2012 · S/N 72022 N1243CEndahl Eric A · Iowa City, IABuilt 1953 · S/N 22-1059 N1243SDecatur Flight Center LLC · Decatur, TXBuilt 1970 · S/N 17259355 N12440Bill Myer Services Inc · Friday Harbor, WABuilt 1973 · S/N 17261983 N12441Jrm Wings LLC · Farmington, UTBuilt 1974 · S/N 17261984 N12442Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 17261985 N12447Pickle Aviation LLC · Yakima, WABuilt 1973 · S/N 17261988 N12448Right Rudder LLC · Rexburg, IDBuilt 1973 · S/N 17261989 N1244APickard Martha Anne Gabriel · Hudson, OHBuilt 1957 · S/N 18-1037 N1244XLackey Lance Harold · New Braunfels, TXBuilt 1963 · S/N 117 N12452Cj Aviation LLC · Sonoma, CABuilt 1973 · S/N 17261992 N12456American Patrols Inc · Midland, TXBuilt 1973 · S/N 17261994 N12459Circle S Aviation LLC · Starkville, MSBuilt 1973 · S/N 17261996 N1245UBello Carlos E · Lawrence, MAS/N 17266940 N1246Lablanc Michael T · Intl Falls, MNBuilt 1954 · S/N 18-3347 N12460Hollenshead Andrew P · Benton, LAS/N 17261997 N12464Bell Todd J · Joliet, MTFirst renewal noticeBuilt 1947 · S/N 12464 N12465Sherburn Daniel E · Spring Lake, MIBuilt 1961 · S/N 22-9057 N12466Leaseair LLC · Wilmington, DEBuilt 1973 · S/N 17261999 N12468Sc Aviation LLC · Mooresville, NCBuilt 1973 · S/N 17262000 N12469Harrington Dara Voss F · Clyde Hill, WAS/N 17262001 N1246AGay Ranch Inc · Broadus, MTBuilt 1951 · S/N 18-1039 N1246CTriplett Michael D · Eastsound, WAS/N 17702689 N1246USnavely Clarella M · Coralville, IABuilt 1976 · S/N 17266941 N12470Pieper Ernest F · Artois, CABuilt 1973 · S/N 17262002 N12473Vero Technical Support Inc · Pensacola, FLBuilt 1973 · S/N 17262003 N12474Tail No N12474 LLC · Brewton, ALS/N 17262004 N12477South Mountain Flying Club Inc · Pittsfield, MABuilt 1973 · S/N 17262005 N12479Nielsen James R · Morgan Hill, CABuilt 1973 · S/N 17262007 N1247CSmith Paul J · Fremont, OHBuilt 1953 · S/N 20-968 N1247JSalazar Raul · Bradenton, FLBuilt 1975 · S/N 247 N1247UDelari Inc · Miramar, FLBuilt 1976 · S/N 17266942 N12483Rucinski Edward A · Climax, NCBuilt 1973 · S/N 17262009 N12484Barber Brothers Rental Properties LLC · Jackson, GABuilt 1973 · S/N 17262010 N12488Davis Matthew B · Almyra, ARBuilt 1973 · S/N 17262014 N1248ABaugh Andrew Lawrence · Anchorage, AKBuilt 1951 · S/N 18-1041 N1248CCollier Luther Neal · Mc David, FLFirst renewal noticeBuilt 1953 · S/N 22-1056 N12492Adragna Michael G · Corfu, NYBuilt 1973 · S/N 17262017 N12493Madden Arthur F · Manville, NJBuilt 1973 · S/N 17262018 N1249AAirmotive Service LLC · Brigham City, UTBuilt 1951 · S/N 18-1042 N1249UJeffries Holdings LLC · Bargersville, INBuilt 1976 · S/N 17266944 N124ABBergevin Steven C · Evergreen, COBuilt 2003 · S/N 008 N124BDMoore Kathryn Cv Julianne · Aguila, AZBuilt 1971 · S/N 124 N124BMPops Space LLC · Luther, OKBuilt 1977 · S/N 071013 N124CTPavilonis Anthony H · Beaver, PABuilt 2011 · S/N 70124 N124ERHeath Jimmie W · Columbia, SCBuilt 1986 · S/N 17276531 N124EWWicker Jeremy · Glen Saint Mary, FLBuilt 2022 · S/N 001

Back to AD 90-04-06 R1