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.
N5152JJames Aviation LLC · Auburn, INN515GTWinston600 LLC · Santa Fe, NMN515VRDream 1 LLC · Carson, CAN516CCMorgan Flight LLC · Saint Paul, MNN516FXC View LLC · Cleveland, OHN516WP516wp LLC · Boca Raton, FLN516WRBank Of Utah Trustee · Salt Lake City, UTN517FXFlexjet LLC · Cleveland, OHN518FXFlexjet LLC · Cleveland, OHN518MBMbi Leasing LLC · Bismarck, NDN51EEArthur J Gallagher (Illnois) LLC · Rolling Meadows, ILN520MBSky Legacy LLC · Kalispell, MTN520RPEcho Acquisitions LLC · Dover, DEN521ABBank Of Utah Trustee · Salt Lake City, UTN521MBRegistered aircraftN522ADCindago LLC · Rancho Cucamonga, CAN523WCN523wc Ltd · Niles, OHN524FXFlexjet LLC · Cleveland, OHN524LBFlyaway Inc · Fort Worth, TXN525FXFlexjet LLC · Cleveland, OHN5262State Street Corp · Shelton, CTN527FXFlexjet LLC · Cleveland, OHN527HRegistered aircraftN527WRBank Of Utah Trustee · Salt Lake City, UTN528TXFlyaway Express LLC · Tomball, TXN529NNAudubon Leasing LLC · Eden Prairie, MNN52SFRdc 2 LLC · Fort Lauderdale, FLN530FXCitation X Parts LLC · Liberty, NCN531RQRegistered aircraftN532JKCrown Avaition Inc · Naples, FLN533XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN534XJTvpx Aircraft Solutions Inctrustee · North Salt Lake, UTN535FXFlexjet LLC · Cleveland, OHN535XJU S Bank Na · Marshall, MNN536FXFlexjet LLC · Cleveland, OHN536XJBank Of Utah Trustee · Salt Lake City, UTN537FXDawsco US Corp · Cleveland, OHN537XJBank Of Utah Trustee · Salt Lake City, UTN538FXFlexjet LLC · Cleveland, OHN538XJBank Of Utah Trustee · Salt Lake City, UTN539KHBlue Bolt Aviation LLC · Vernal, UTN539XJBank Of Utah Trustee · Salt Lake City, UTN540FXFlexjet LLC · Cleveland, OHN541DTBank Of Utah Trustee · Salt Lake City, UTN541FXCitation X Parts LLC · Liberty, NCN541XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN542FXCitation X Parts LLC · Liberty, NCN543EETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN544FXAres Technical Administration LLC · Cleveland, OHN545CUniversal Church Inc · Newark, NJ
Back to AD 2018-04-13