AD 2019-08-13
Registered aircraft · 1,554
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:2019-08-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2019-08-13')
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:2019-08-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2019-08-13') 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.
N151GMHei Aviation LLC · Powell, OHN152KVPlane House LLC · Indianapolis, INN153CJAbbey Air Inc · Birmingham, ALN153TJDavis Air LLC · Vero Beach, FLN155BWPoet Inc · Sioux Falls, SDN155CGBigees Air LLC · Sioux Falls, SDN156MLAir Miles LLC · River Falls, WIN157TWHf Air LLC · Fresno, CAN159JSB&L Adventures LLC · Sealy, TXN15EDClearview Aviation Group LLC · Peachtree City, GAN15WEFirstrike Aviation LLC · Tulsa, OKN15YDN15yd LLC · Lewes, DEN15ZZShamrock Air LLC · Arnold, MON160BRDft LLC · Central Point, ORN162CBKjt Aviation LLC · Beaumont, TXN162ECCitation Dreams LLC · Inlet Beach, FLN16WBPacebook Aviation LLC · Albany, GAN170MRN170mr LLC · Bend, ORN170MUCitationjet 525 LLC · Wilmington, DEFirst renewal noticeN170TMJba LLC · Berkeley, CAN174AACorsair Two LLC · Hillsboro, ORN174SJSierra Juliet LLC · Greeley, CON175AACorsair Two LLC · Hillsboro, ORN175RDGaltstream LLC · Greenwood Village, CON176BKWildcat Aviation LLC · Colby, KSN1776WRegistered aircraftN177VVDodson International Parts Inc · Rantoul, KSN178MPAirtrust LLC - 6 - Series 6 Trustee · Sheridan, WYN179ERMedd II Aircraft LLC · Zelienople, PAN179WCBailburch Aviation LLC · Little Rock, ARN17LJGenetech Animal Reproduction LLC · Purcell, OKN17QCOncourse Air LLC · Rogers, ARN17VBN17vb LLC · Nacogdoches, TXN181WENew Pig Corp · Tipton, PAN181WSSierra Western Aero LLC · Wentzville, MON183TXCrump Properties LLC · Jasper, ALN18466Pantaxios LLC · Spencerport, NYN1863WKansas State University · Salina, KSN1865CHotel Alpha LLC · Tampa, FLN186DLAesop LLC · Las Vegas, NVN186TWTnp Aviation LLC · Valdosta, GAN1875CFalcon Ridge LLC · Longview, TXN187MCAe Aircraft LLC · Longview, TXN188MPAircraft Guaranty Corp Trustee · Oklahoma City, OKN188SBHigh Flyers LLC · Hobbs, NMN189MSAviation II Inc · Tulsa, OKN18KStrata Aviation LLC · Durham, NCN18TFAirflite Financial Company LLC · Alpena, MIN1933SSunflower Sand LLC · Akron, OHN193PPMarietta Silos LLC · Marietta, OH
Back to AD 2019-08-13