AD 2012-06-01
Registered aircraft · 726
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:2012-06-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-06-01')
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:2012-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-06-01') 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.
N789KGRps Air LLC · Bucyrus, KSN78XLGarmin International Inc · Olathe, KSN790TXEgret Flyers LLC · Winston Salem, NCN798TAgeless Mens Health Holdings Inc · Scottsdale, AZN7TMAeonian Air LLC · West Chester, PAN800AMReading And Northern Aviation Inc · Port Clinton, PAN800KVOnin Ascend LLC · Birmingham, ALN801JSCitation 1 Juliet Sierra LLC · Uvalde, TXN802TDAlliance Aviation Group LLC · Wilmington, DEN803JSFe 5272 LLC · Kinston, NCN804BCClary Aviation LLC · Longview, WAN805BLShepair LLC · Virginia Beach, VAN806JS83 Aviation LLC · Fort Lauderdale, FLN807JSDx Air Fleet LLC · Daytona Beach, FLN808MNMilliken & Company · Greer, SCN808SDDrillers Aviation LLC · Mt Morris, PAN809JSFe 5094 LLC · Kinston, NCN80AEAerocatalyst LLC · Detroit, MIN80FDAma Freight LLC · Saint Clair Shores, MIN80XAirxl LLC · Carmel, INN810JBUnified Air Solutions LLC · Oldsmar, FLN810JSAircraft Trust & Financing Corp Trustee · Wilmington, DEN811CEArchie LLC · Hamilton, OHN812BPDel Papa Holdings LLC · Beaumont, TXN817BSAerodan Aviation LLC · Alpharetta, GAN817BZBrazos Aviation LLC · Fort Worth, TXN817EGEng Capital LLC · Houston, TXN817LFPollard Aircraft Sales Inc · Fort Worth, TXN818BLBrenmar Corp · Lawrenceville, GAN823JSAero Harbor Nc Ll · Charlotte, NCN824JSFe 5536 LLC · Kinston, NCN827CRCamar Express LLC · Tallahassee, FLN827DPN827dp LLC · Boyertown, PAN828DRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN82GTTextron Financial Corp · Wichita, KSN82HESummers-Taylor Inc · Johnson City, TNN82KWRegistered aircraftN830JGGlflights LLC · San Antonio, TXN830JSRoss Advisors LLC · Naples, FLN831GLFw Equipment Leasing LLC · Batesville, ARN833JSFe 5107 LLC · Kinston, NCN835JSCt Equipment Leasing LLC · Kinston, NCN836JSFe 5186 LLC · Kinston, NCN837JSFe 5164 LLC · Kinston, NCN838CBank Of Utah Trustee · Salt Lake City, UTN838JSFe Encore Plus III LLC · Kinston, NCN839JSRenflight LLC · Raleigh, NCN83GBExcel 5 LLC · Columbus, GAN83LXLx Aviation LLC · Little Rock, ARN83SPKelbel Aviation LLC · Longview, TX
Back to AD 2012-06-01