AD 90-04-06 R1
Registered aircraft · 68,377
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
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.
N8132YJessen Eric Carl · La Luz, NMN81337Bandito Aviation LLC · Naples, FLN8133CCarter Marl · Coburg, ORN8133ELane Community College · Eugene, ORN8133JWarrior Aviation LLC · Stanford, KYN8133YLeaders Bob O · Clear Lake, MNN81344November 46a Leasing Inc · St Augustine, FLN81345Bailey Roger I · Silverdale, WAN81347Tusha Kenneth R · Yankton, SDN8134CCentral Virginia Aviation Inc · North Dinwiddie, VAN8134DDewolf Logan J · Eagle River, AKN8134WBrilliant Holdings LLC · Winfield, MON81354Figueroa Lionel · Sacramento, CAFirst renewal noticeN81357Cascade Aircraft LLC · Eugene, ORN81359Tuckahoe Aviation LLC · Tequesta, FLN8135CCoverdale Aviation LLC · Ellendale, DEN8135DDickerson Joseph Ra · Anchorage, AKN8135GMiloud Chadd K · Fort Worth, TXN8135JWilbur-Ellis Co · Salinas, CAN8135LTri County Rentals And Sales Inc · Bell, FLN8135PStein David J · New Port Richey, FLN8135WWoodrum Alan D · Danville, ILN81360Ayer Edward Wayne · Warner Robins, GAN81364F2f LLC · Milford, CTN81367Johnson David M · Baltimore, MDN81368Steinruck Thomas III · Temple Terrace, FLN8136JRiti Inc · Jackson, TNN8136QVenture West LLC · Mesa, AZN8136WNajjar Craig S · Norwood, MAN81376Spackman Timothy Oliver · Houston, TXN81377Mcgaughy Ellis H · Eastover, NCN8137QUnited States Air Force · Hanscom Afb, MAN8137UMiloud Chadd K · Fort Worth, TXN8137YSale Reported · Chisago City, MNSale reportedN81382Schear Brian · Costa Mesa, CAN81384Royals Navy LLC · Lewes, DEN81388Byrne Jan · Greenwood, INN8138DAir Group Inc · Marietta, GAN8138EMorris John A · Phoenix, AZN8138HAccelerated Aviation Instruction LLC · Owatonna, MNN8138LN8138l LLC · Metairie, LAN8138WSky Air Inc · Cedar Rapids, IAN8138YBelmont Aviation LLC · Port Saint Lucie, FLN81391Gibney Frank A · Colchester, VTN81398Mast Henry V · Dayton, TXN8139EElliott Carl J · Fort Worth, TXRegistration revokedN8139NPerucca Douglas E · Wasilla, AKN8139WHigh Five Flight Inc · Dawson, NEN8139YBuchanan Jason A · Meridian, IDN813BSutter Timothy C · Glennallen, AK
Back to AD 90-04-06 R1