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.
N413DPYale Companies LLC DBA · Fishers, INN413EBG&M Aircraft Inc · Wheat Ridge, CON413EFIsland Aviation LLC · East Greenwich, RIN413JSClearwake Inc · Kaysville, UTN413KTAce Tomato Company LLC · Mcgregor, TXN413LHRatcliff Dustin Matthew · Saltville, VAN413LMRba LLC · Kimberly, IDN413MASterling Flight Training LLC · Jacksonville, FLN413MMDoyle Brian G · Westfield, MAN413NDUniversity Of North Dakota · Grand Forks, NDN413RBLarson Cody Q · Dillingham, AKN413THPiper Aircraft Inc · Vero Beach, FLN413WCBradshaw Larry C · Edgewood, TXN413WPKcsi Aerial Patrol Inc · Bakersfield, CAN413YKGoodner Terry Jack · Port Saint Lucie, FLN413ZPPettinger Tom W · Cody, WYN4140JStone Raymond M · Moore, OKN4140PRenda Gregory L · Saratoga, CAN4140WBird Acquisition LLC · Phoenix, AZN4140XOtt Dean R · Carrollton, OHN4140YBuckman Dean D · Monroe City, MON4140ZMeierotto Jeff T · Two Rivers, AKN41412Walters Haskell L · Gold Hill, NCN41415Cavins Todd J · Stillwater, OKN41416Lewis Elijah J · Luthersville, GAN41419Ater Mark · Greenville, OHN4141HBizy Eves Enterprises LLC · San Antonio, TXN4141KKimminau Jeremy · Sacramento, CAN4141UMoss James L · Lansing, IAN4141YWells Kevin R · Elko, NVN4141ZBalmer Jeffrey A · Crosslake, MNN41421Blue Angel Properties LLC · Poland, OHN41429Straight Arrow LLC · Kuna, IDN4142BKnutson Wayne R · Tioga, NDN4142MMiddleton William A Jr · Crestwood, KYN4142YRegistered aircraftN41434Groner Frank · Montrose, ALN41439Lesher James · Farmington, NMN4143ASkywest Leasing Inc · St George, UTN4143PSparrowhawk Aviation · Manvel, TXN4143USwerczek Gerald Edward Jr · Tallahassee, FLN4143XBoeing Co · Renton, WAN4143YHasenfus Heidi J · Green Cove Springs, FLN4143ZRavenscroft Brant A · Box Elder, SDN41449Maccani Mark J · Bessemer, MIN4144ETradewind LLC · Wasilla, AKN4144JMclean Yvonne A · Warfordsburg, PAN4144KBoard Of Trustees · Savoy, ILN4144MSannon Michael R · Fairview, MTN4144PChandler Air Service Inc · Chandler, AZ
Back to AD 90-04-06 R1