AD 2016-08-18
Registered aircraft · 399
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:2016-08-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-18')
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:2016-08-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-18') 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.
N8063MFriar Aerospace Group LLC · Jacksonville, FLN807ABSunward Aviation Services LLC · Merritt Island, FLN808ABSunward Aviation Services LLC · Merritt Island, FLN80GVMoro Aircraft Leasing Inc · Two Rivers, AKN812TBTwin Aviation LLC · Coushatta, LAN8131Regional Air & Transport LLC · Mims, FLN818BRMarc Inc · Bolton, MSN81EDNav-Pete LLC · Memphis, TNN820FSAir Arctic Inc · Fairbanks, AKN820JHHughes Leasing Co · Miami, FLN824PGMount Olive Flight Club LLC · Mount Olive, NCN827RDGoyo Air LLC · Miami, FLN828HJPegasus Air Charter LLC · Hartford, CTN828KTJones Larry · Anchorage, AKN834NQAlaska Door LLC · Wasilla, AKN849DWCsc Delaware Trust Co Trustee · Wilmington, DEN868ETSale Reported · Eagle OranjestadSale reportedN86VADe Leon Inc · Perth Amboy, NJN880RCPuerto Rico Aircraft Leasing Corp · Ceiba, PRN885HAFox Airways LLC · Wasilla, AKN888JJGst Inmotion LLC · Kalispell, MTN888LMAir Mods And Repair · Robbinsville, NJN888PCAirmonarc LLC · Orlando, FLN888YAAds-B Technologies LLC · Anchorage, AKN88TGMakushin Logistics LLC · Fairbanks, AKN88TLAh Legacy LLC · Orlando, FLN88ZMFlorida Aero Services Sales Division Inc · Brandon, FLN890HMarc Inc · Bolton, MSN904SCMedical Disposables Corp · Orlando, FLN905TJWhittington Peter M · Jupiter, FLN919BBAf Land Ventures LLC · Palm City, FLN91PWAerial Imaging Inc · South Bend, INN9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLN926HBAwmr LLC · Conroe, TXN92BLIsland Birds Inc · St Thomas, VIN931SAMarc Inc · Bolton, MSN938PMD & B Aviation LLC · Stroudsburg, PAN942EAngry Manx LLC · Riverside, CAN95KAAirborne Resources Inc · Midlothian, TXN95TCMmec Air LLC · Oxford, MSN961PAThiel Bros Roofing Inc · Sidney, MTFirst renewal noticeN96342Aircraft & Aviation Professionals LLC · Coldwater, MIN974CSMcgregor Daniel A · Denali Natl Park, AKN97MADodson International Parts Inc · Rantoul, KSN9901Noiw Resources LLC · Belle Chasse, LAN995AKLake Clark Air Inc · Port Alsworth, AKN9993RCsc Delaware Trust Co Trustee · Wilmington, DEN999GKTaylor Craig E · Nantucket, MAN9FWWright Air Service Inc · Fairbanks, AK
Back to AD 2016-08-18