Skip to content

Registered aircraft · 20,683

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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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.

N708LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11474 N708RFHilton Charles Larry · Arcadia, FLBuilt 1964 · S/N 17250695 N708TEAileron Aviation Inc · Cookeville, TNBuilt 1978 · S/N 17270934 N7091ASears Rusty M · Alma, GAS/N 29191 N7091GSkylark Flight Training LLC · Wilmington, DEBuilt 1969 · S/N 17258791 N7091TJensen William Robert · Zephyrhills, FLFirst renewal noticeBuilt 1959 · S/N 46691 N7092GAmick Thomas C · Newberry, SCBuilt 1969 · S/N 17258792 N7093AValle Daniel J · Canton, MIBuilt 1956 · S/N 29193 N7093GAero Performance LLC · Scooba, MSBuilt 1969 · S/N 17258793 N7094GJohnson And Assoc · Davenport, IABuilt 1969 · S/N 17258794 N7094QRegistered aircraftBuilt 1972 · S/N 17260394 N7095GHunter John Bockett · Riverton, NJBuilt 1969 · S/N 17258795 N7095QWong Henry L III · Lake Forest, CABuilt 1972 · S/N 17260395 N7095TCurrence Brian J · Rock Hill, SCS/N 46695 N7096AWhite Lee A · Columbus, OHS/N 29196 N7097GMurdy David C · Round Rock, TXBuilt 1969 · S/N 17258797 N7099GHunt Howard E · Martinsville, ILBuilt 1969 · S/N 17258799 N7099QVenaleck John T · Painesville, OHBuilt 1972 · S/N 17260399 N7099TDls Aviation LLC · Missoula, MTBuilt 1959 · S/N 46699 N709LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 172S11419 N709MWGrant Michael R · South Weber, UTBuilt 1968 · S/N 172-56629 N709PTCappe Investment Group LLC · Homestead, FLS/N 17261533 N70DKParmley Terry R · Michigan City, INBuilt 1963 · S/N 17255493 N70DMMl Flight Services LLC · Miami, FLBuilt 1974 · S/N 17263728 N70JAN70ja LLC · Stuart, FLBuilt 1998 · S/N 17280660 N70KPPrichard Kevin L · Enterprise, KSBuilt 1969 · S/N 17257954 N70RSStriplin James R Jr · Hartford, ALBuilt 1959 · S/N 46470 N70SUOhio State University · Columbus, OHBuilt 1998 · S/N 17280460 N70TASixty Three Charlie Zulu Inc · Thonotosassa, FLBuilt 1979 · S/N 17272891 N7100ANoel Roberto Vallejo LLC · Orem, UTS/N 29200 N7100GBoyd John J · Wasilla, AKBuilt 1969 · S/N 17258800 N7100TDillman Robert F · Suffolk, VABuilt 1959 · S/N 46700 N7101AChickasha Wings Inc · Chickasha, OKBuilt 1956 · S/N 29201 N7101GBowhawk LLC · Ocala, FLBuilt 1969 · S/N 17258801 N7101TLee Terry R · Little Canada, MNS/N 46701 N7102GBarbosa Manuel · Apple Valley, MNBuilt 1969 · S/N 17258802 N7102QJuckett Jimmy L · Springhill, LABuilt 1972 · S/N 17260402 N7103ACady Marshall J · Seadrift, TXS/N 29203 N7103GMountain Flyers Inc · Hendersonville, NCBuilt 1969 · S/N 17258803 N7104GAir Carriage LLC · Chico, CABuilt 1969 · S/N 17258804 N7105ADunkley Judith A · London, OHS/N 29205 N7107ASlingerland Rex · Grand Haven, MIBuilt 1956 · S/N 29207 N7107TRaetzke Bradley · Columbus, OHBuilt 1959 · S/N 46707 N7108GLakes Area Aviation LLC · Little Falls, MNS/N 17258808 N7108QAnderson Michael · Hillsboro, NDBuilt 1972 · S/N 17260408 N7109QLawless Bruce A · Lago Vista, TXBuilt 1972 · S/N 17260409 N7109TOwens Emmett E · Madison, INBuilt 1959 · S/N 46709 N710LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 172S11420 N710SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13577 N710SPElite Approach LLC · Chesterfield, MOBuilt 1999 · S/N 172S8106

Back to AD 90-06-03 R1