Skip to content

Registered aircraft · 68,375

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.

N30145Keno Aviation LLC · Marshfield, MAS/N 17701077 N30147G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7990085 N30148Tyler Marion B · Lacey, WABuilt 1968 · S/N 17701079 N3014HBad Dog Aviation Inc · Meridianville, ALBuilt 1978 · S/N 28-7916182 N3014MBaum James L Trustee · Anchorage, AKBuilt 1947 · S/N 12-1572 N3014TSlaney Richard C · Eugene, ORBuilt 1973 · S/N BH120/212 N30151Miller Jacob G · Harrison, ARFirst renewal noticeS/N 17701081 N30153Waters Donovan D · Peoria, AZBuilt 1968 · S/N 17701082 N30157Cardinal Aviation LLC · Pelham, NHBuilt 1968 · S/N 17701086 N30158Segroves Jeffrey S · Milledgeville, GABuilt 1968 · S/N 17701087 N3015DFlywell Flying Club Inc · Roseville, MNBuilt 1978 · S/N 28-7990171 N3015ECuevas Ernesto · Orlando, FLBuilt 1978 · S/N 17271404 N3015UCoastal Fliers Inc · El Cajon, CABuilt 1979 · S/N 28-7990335 N3015ZPittman Leo B · Stanfield, AZBuilt 1959 · S/N 22-6966 N30166De Jager Henry · Smithville Flats, NYBuilt 1968 · S/N 17701093 N3016MWild Wingdom LLC · Greenville, SCBuilt 1978 · S/N 28-7890284 N3016TWilson Michael L · Santa Maria, CABuilt 1979 · S/N 28-7916298 N3016WBramble And Schaffer Aviation LLC · Raleigh, NCBuilt 1979 · S/N 28R-7918086 N30179Kowatra Anil K · Lilburn, GABuilt 1968 · S/N 17701103 N3017GBecker Lyle A · Anchorage, AKBuilt 1968 · S/N 511 N3017HDavis Ronald C · Bloomington, MNS/N 28-7916184 N3017MRwm Aviation LLC · Kalispell, MTBuilt 1947 · S/N 12-1714 N3017VCraddock Charles Bert · San Fernando, CABuilt 1975 · S/N 0867 N30182Johnson Arnold R · Mina, SDBuilt 1968 · S/N 17701105 N30184Cp Aviation Inc · Santa Paula, CABuilt 1974 · S/N 17264125 N30189Onguard Aviation LLC · Cottonwood Falls, KSBuilt 1968 · S/N 17701108 N3018ZGorman Robert L · Los Gatos, CABuilt 1979 · S/N 28-7916398 N30195Palmer Peter L · Mission, TXBuilt 1968 · S/N 17701113 N30198Thomas Mark J · Vacaville, CABuilt 1968 · S/N 17701115 N3019LWatkins Daniel J · Kennett Square, PABuilt 1983 · S/N 7-0136 N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928 N301ACFlying Squirrel Aviation LLC · Shirley, MABuilt 1995 · S/N 744-95 N301AVJackson Charles A · Winchester, KYBuilt 1976 · S/N 28-7715070 N301BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020284 N301BPPrecision Aviators LLC · Iuka, ILBuilt 1991 · S/N 1983 N301DTDawson Taylor Enterprises LLC · Dover, DEBuilt 1998 · S/N 0081 N301ECF N A Aviation LLC · Wakefield, MABuilt 2025 · S/N 2881980 N301EMMcconwell Edward A · Mission, KSBuilt 1965 · S/N 30-916 N301FSNadh Development LLC · Santa Rosa, CABuilt 2022 · S/N 1565 N301HEN301he LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2382M N301JKKaminski John J · Torrance, CABuilt 1978 · S/N 24-0634 N301JRTropitech Inc · San Juan, PRBuilt 1973 · S/N 17261555 N301JSOlson Nicholas D · Ankeny, IABuilt 1993 · S/N JS001 N301KCRidl Kent S · West Fargo, NDBuilt 1978 · S/N 24-0414 N301KMDexter Fred H · Live Oak, FLS/N 001KEP N301MXRockin T Construction Inc · Swan Valley, IDBuilt 1998 · S/N 1391 N301NDPutzke Becky A · Fort Ripley, MNS/N 17261763 N301RCAero Hound LLC · Lewes, DEBuilt 2008 · S/N 3039 N301SMCameron Ottis W · Comfort, TXFirst renewal noticeBuilt 1964 · S/N 534 N301STTechnical Education Services Inc · Virginia Beach, VAS/N 28-25655

Back to AD 90-04-06 R1