AD 2018-04-13
Registered aircraft · 1,373
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:2018-04-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:2018-04-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:2018-04-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:2018-04-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.
N309JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN30PXRegistered aircraftN30QAWood Asg LLC · Carrollton, TXN30WDKing Aviation LLC · Dallas, TXN310JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN310KEOneok Inc · Tulsa, OKN310VZRan Air LLC · Driggs, IDN311FCWheels Up Partners LLC · New York, NYN311GSCh Aircraft LLC · Palm Beach, FLN312EAAea Services LLC · Delray Beach, FLN312HCUS Bank Na Trustee · Hartford, CTN313CFEvans General Aviation LLC · Alpharetta, GAN313DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN313VClyde Companies Inc · Orem, UTN314JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN314WCJrcg280 LLC · Houston, TXN315JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN316CSCaroler 316 LLC · Solon, OHN316FXFlexjet LLC · Cleveland, OHN317FXStanley Steemer International Inc · Cleveland, OHN317JCFlying Horse Aviation LLC · Colorado Springs, CON317VBVictor Bravo Air LLC · Dallas, TXN318CMCarter Aviation LLC · Salem, VAN318FXFlexjet LLC · Cleveland, OHN319FXFlexjet LLC · Cleveland, OHN31CAHf Sinclair Payroll Services Inc · Dallas, TXN31MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLN31TFN31tf LLC · Machesney Park, ILN320FXBraxton Aviation II LLC · Cleveland, OHN320JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN320KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN320LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN321FXConnie 749 LLC · Cleveland, OHN322FXYnwa LLC · Cleveland, OHN323FXRegistered aircraftN324FXBoardwalk Auto Group LLC · Cleveland, OHN325FXFlexjet LLC · Cleveland, OHN325PEPeco Air LLC · Park City, UTN325TGFlying G Aviation LLC · Atlanta, GAN325WJDorado Aircraft Leasing LLC · Jupiter, FLN326FXTriple F Management LLC · Cleveland, OHN327FXCp Wings II LLC · Cleveland, OHN328FXFrank J Blair · Cleveland, OHN328RSHolloman Ventures Aviation LLC · Houston, TXN329FXFlexjet LLC · Cleveland, OHN32JF32jhf LLC · Phoenix, AZN32TSCsc Delaware Trust Company Trustee · Wilmington, DEN32TXPresidio Air Ventures LLC · Houston, TXN330FXRegistered aircraftN330PJKhcl LLC · Cincinnati, OH
Back to AD 2018-04-13