Skip to content

Registered aircraft · 630

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:87-11-01-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:87-11-01-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:87-11-01-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:87-11-01-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:87-11-01-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:87-11-01-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.

N4094BClosson Luke E Jr · Valdosta, GABuilt 1975 · S/N 75-30782 N4101BBerry Larry A · Bryan, TXBuilt 1974 · S/N 74-31106 N4102BLamay James R · Reno, NVBuilt 1977 · S/N 77-31136 N4109BMccowan Joseph F · Sylvania, OHBuilt 1974 · S/N 75-30760 N4113BRishell Charles G · Columbia, MDBuilt 1974 · S/N 74-32-145 N4133BMachinerywatch.Com Inc · Louisa, VABuilt 1975 · S/N 75-30795 N4134BWildrose Aviation LLC · Victor, CABuilt 1974 · S/N 74-31102 N4135BBice Christopher S · Summerville, SCS/N 76-30808 N4137BWalker James D · Grapevine, TXBuilt 1974 · S/N 75-30738 N4141BWright Eric K Sr · Wills Point, TXBuilt 1975 · S/N 75-32-160 N4147BBaughman David W · Tijeras, NMBuilt 1976 · S/N 76-31128 N4151BCraig Scott W · Sorento, ILBuilt 1974 · S/N 75-32-152 N4156BNance Gerald D · Bladenboro, NCBuilt 1975 · S/N 75-30789 N4157BHarboe Nicolaus C · Bartow, FLBuilt 1974 · S/N 75-30729 N4158BCapristo Construction · Cape Coral, FLS/N 76-30801 N4165BGood Decision Aviators LLC · Noble, OKBuilt 1975 · S/N 76-30799 N4173BBeck Nicholas G · Ione, CABuilt 1975 · S/N 75-30792 N4176BWard William R · Titusville, FLBuilt 1975 · S/N 75-30781 N4181BOsterberg Douglas L · Neenah, WIS/N 75-30770 N4184BWitt Aaron K · Hooker, OKBuilt 1974 · S/N 75-30742 N4201BNrnc LLC · Camden, DEBuilt 1975 · S/N 75-30775 N4204BLieske William R · Lonsdale, MNBuilt 1974 · S/N 75-30753 N4205BStasson Robert K · Sikes, LABuilt 1974 · S/N 75-32-146 N4210BAkin Andrew D · Senoia, GAS/N 75-30757 N4241BBor-It Mfg Co Inc · Ashland, OHBuilt 1974 · S/N 75-30727 N4243B43 Bravo LLC · Maple Grove, MNBuilt 1974 · S/N 74-30724 N425BBGarcia Robert Lee · Horseshoe Bay, TXBuilt 1968 · S/N 30099 N429FSSimmons Frederick G · Lake Hiawatha, NJBuilt 1971 · S/N 32-54 N432DMRegistered aircraftSale reported, pending cancellationBuilt 1971 · S/N 30413 N4365VPfander Scott J · Litchfield Park, AZBuilt 1972 · S/N 73-30487 N4440BHaustrom Curtis R · Barnesville, OHS/N 73-30614 N44TLEco-Logic Environmental Engineering Inc · Placentia, CABuilt 1979 · S/N 80-30973 N452SKAlcock Shane Vincent · Temple, TXBuilt 1972 · S/N 73-30522 N4702VBrown Anthony · Pacoima, CABuilt 1967 · S/N 30053 N4703VLangham William Hb · Uvalde, TXBuilt 1967 · S/N 30054 N4714VSwanland Robert C · Grants Pass, ORBuilt 1967 · S/N 30069 N4716VFields William F · Hazard, KYBuilt 1967 · S/N 30068 N4720VBurr Philip A · Bethel, CTBuilt 1967 · S/N 30060 N4733VEdwards James W · Del Norte, COBuilt 1967 · S/N 30066 N4736VRegistered aircraftBuilt 1967 · S/N 30067 N4744VSettle David A · Lyons, KSBuilt 1967 · S/N 30073 N4745VFiecke Rodney J · Cokato, MNS/N 30074 N4747VRegistered aircraftBuilt 1967 · S/N 30036 N4799VDeparture Aviation Services LLC · Laurel Hill, NCS/N 30088 N479SVKollstedt Lance S · Tipp City, OHBuilt 1979 · S/N 79-30950 N4802VWilcox Chad R · Muncy Valley, PABuilt 1967 · S/N 30082 N4822VCantrell David R · Albany, GABuilt 1968 · S/N 30092 N4830VAkin Allen Kent · Midland, TXBuilt 1968 · S/N 30095 N4847VNutter Michael S · University Place, WABuilt 1968 · S/N 30102 N4855VGlide Slope Aviation Inc · Myakka City, FLBuilt 1968 · S/N 30109

Back to AD 87-11-01 R1