AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N6721ESonoma Valley Aircraft Inc · Vineburg, CAN6721SRenwick Stephen P · Moss Beach, CAN6722GPiasa Flyers Inc · East Alton, ILN6722SCampbell J Tyler · Chestertown, MDN6723GPressley Brandon S · York, SCN6724AGodin George A · Franklin, VTN6725ESocal Jet Services Inc · Long Beach, CAN6725FReberry Brian Keith · Boise, IDN6725GJohnson Andrew E · Prior Lake, MNN6725SMarshall Jerry J · Parker, AZN6726FBlackford Robert G · Summit Point, WVN6728ELincoln Gene T · Delta, CON6728SStevens Matthew S · Penn Yan, NYN6729AO Tuel Maxcy Bryant · Mooresville, NCN6729FLuke David E · Lubbock, TXN6729GBelgacem Yassine · Harrisburg, PAN6729SCain Tyler M · Houston, TXN672CCDmac Aircraft LLC · Savannah, GAN6731SHaug Jeffrey S Trustee · Leawood, KSN6732AHurst Construction Co · Denton, TXN6732FSmith Tyler C · Wasilla, AKN6733AJaed Gerald E · Yankeetown, FLN6733CBerry Michael C · Stanfield, AZN6733GAsaro Carlo · Waterbury, CTN6734HLindroth Richard J · Eleanor, WVN6734JApex Airmotive LLC · Frisco, TXN6735AHinkle Robert J · Caldwell, IDN6735EPollock Patrick B · Temecula, CAN6735GRedeemed Flying Corps Association · Oklahoma City, OKN6736AFogleman Brian L · Stonewall, LAN6736FN6736f LLC · Port Saint Lucie, FLN6737AEdmiston Dave L · Clifton, TXN6738ABufford David T · Union Springs, ALFirst renewal noticeN6738EHaering Harold J Jr · Downers Grove, ILN6738GSpark Aero LLC · Christiansburg, VAN6738HTucker Nelson DBA · Hartford, ALN673CBBurge Jerome C · Thousand Oaks, CAN673XBusy Bee Ventures Inc · Cherokee, NCN6740AWillis John Y · Pine Mountain, GAN6740EDoughty Gregory · Wheaton, ILN6740FUwanawich Miller · Los Angeles, CAN6741EIntegrating Aviation & Ministry · Coldwater, MIN6742ABouton Vern H · Fairbanks, AKN6743EPop Ciprian S · Reno, NVN6744ALa Rue Carl A · Cambridge, OHN6744GRenfrow Denny M · Kelseyville, CAN6744SGoodrich Flying LLC · Corinne, UTN6746EKobberdahl Marcel A · Deerwood, MNN6746GKelsay Roger B · Hillsboro, ORN6747AMatt Brit A · Sioux Falls, SDFirst renewal notice
Back to AD 94-05-05 R1