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.

N6065LAvolant Aviation LLC · Mooresville, NCBuilt 2006 · S/N 172S10250 N6065MPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10251 N6065PS R Liner LLC · Canton, MABuilt 2006 · S/N 172S10253 N6066AAndrews Peter F · Rangeley, MEBuilt 1956 · S/N 28666 N6067RZhu Kevin · Tigard, ORBuilt 1965 · S/N 17253736 N6068AWillerscheidt Thomas H · Mukwonago, WIBuilt 1956 · S/N 28668 N606DBBode Aviation Inc · Albuquerque, NMBuilt 2002 · S/N 17281141 N606LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2008 · S/N 172S10708 N606NDDavidson Flight Service LLC · Gig Harbor, WABuilt 2013 · S/N 172S11296 N606TCWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280152 N6070APolin Keith A · Belen, NMS/N 28670 N6070RHodgson E Russell · Nevada City, CABuilt 1965 · S/N 17253739 N6071AJones Jane · Portland, ORBuilt 1956 · S/N 28671 N6074FFly America Inc · Palo Alto, CABuilt 2008 · S/N 172S10680 N6074RKray Timothy P · Lincoln, NEBuilt 1965 · S/N 17253743 N6075RNelsn Hans A · Sergeant Bluff, IABuilt 1965 · S/N 17253744 N6076ABack Daryl · Stephenville, TXBuilt 1956 · S/N 28676 N6076RAdvanced Targeting Solutions LLC · Perkasie, PABuilt 1965 · S/N 17253745 N6077AHall James E III · Lumber Bridge, NCBuilt 1956 · S/N 28677 N6077RCultra Daniel L · Rochelle, ILS/N 17253746 N6078ASnell Jeffrey D · Inver Grove Hghts, MNBuilt 1956 · S/N 28678 N6078ROancea Traian · Oakdale, CABuilt 1965 · S/N 17253747 N6079ARegistration Pending · Hartford, SDRegistration pendingBuilt 1956 · S/N 28679 N6081ABoykin Bobby · Brandon, MSS/N 28681 N6081RWatler John L · Brazil, INBuilt 1965 · S/N 17253750 N6083JB&R Aircraft LLC · Wadsworth, OHBuilt 1980 · S/N 17273853 N6083RHatle Arlen J · Meadow, SDFirst renewal noticeBuilt 1965 · S/N 17253752 N6083VScholz Francis M · Atchison, KSBuilt 1980 · S/N 172RG0571 N6084RKdb Flying LLC · Branchville, SCBuilt 1965 · S/N 17253753 N6086AWatson Johnna A · Sonoma, CABuilt 1956 · S/N 28686 N6086GAbovestandard LLC · Denison, TXBuilt 1979 · S/N 17273566 N6087AFlood Plain Farm And Mercantile LLC · Curlew, WABuilt 1956 · S/N 28687 N6087RPalmenteri Winston D · Rhome, TXS/N 17253756 N6088AStrickland Vernon G · Fort Worth, TXBuilt 1956 · S/N 28688 N6088RPruette Jason · Oakland, CABuilt 1965 · S/N 17253757 N6089KDelta State University · Cleveland, MSBuilt 1980 · S/N 17274166 N6089RLeadbetter Roy A · Georgetown, TXS/N 17253758 N608DLByler Jason M · Middlefield, OHS/N 17274998 N608EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12707 N6090ARegistered aircraftBuilt 1956 · S/N 28690 N6090RPaul Rowe Memorial Airport Association Inc · Kahoka, MOBuilt 1965 · S/N 17253759 N6090VRoberts Jon J · Parker, COBuilt 1980 · S/N 172RG0573 N6091ABarrientos Jeri · Collinsville, OKS/N 28691 N6091DMentone Flying Club · Rochester, INBuilt 1979 · S/N 17272599 N6091VJames Jay C · Mesa, AZBuilt 1980 · S/N 172RG0574 N6092FJasper Aviation Inc · Jasper, ALBuilt 1979 · S/N 17273146 N6092RBrock Roy C Jr · Pilot Point, TXBuilt 1965 · S/N 17253761 N6092VAir Venture LLC · Au Gres, MIBuilt 1980 · S/N 172RG0575 N6093ARecker Nicholas P · Franklin, TNBuilt 1956 · S/N 28693 N6093JAir S & T LLC · San Juan Capo, CAFirst renewal noticeBuilt 1980 · S/N 17273856

Back to AD 90-06-03 R1